Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SelectAll in TextBox?

Discussion in 'Information Technology' started by redundantman, Jul 28, 2006.

  1. redundantman

    redundantman
    Expand Collapse
    Guest

    Hey all, I have a textbox on a form in Access97. I only want users to enter
    a capital "A" or a captial "E" in the textbox. What is the easiest way to
    accomplish this in Access?

    If I set the InputMask to ">L?" it works but ONLY if I tab into the field.
    If I click into the field then it won't let me type anything.

    I thought you could do something like textbox.SelectAll to automatically
    select all the text in a textbox when you enter it but that doens't appear to
    be an option.

    tia,
    dan c
    --
    http://redundantman.tripod.com
     
  2. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    Set the validation rule (in the table) to
    Like "A" Or "E"

    This will be cloned to any forms (if you already have the text box - delete
    it and re-insert)

    Hope his helps



    "redundantman" wrote:

    > Hey all, I have a textbox on a form in Access97. I only want users to enter
    > a capital "A" or a captial "E" in the textbox. What is the easiest way to
    > accomplish this in Access?
    >
    > If I set the InputMask to ">L?" it works but ONLY if I tab into the field.
    > If I click into the field then it won't let me type anything.
    >
    > I thought you could do something like textbox.SelectAll to automatically
    > select all the text in a textbox when you enter it but that doens't appear to
    > be an option.
    >
    > tia,
    > dan c
    > --
    > http://redundantman.tripod.com
     

Share This Page