Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Input Masks and data entry (2000 (9.0.4402 SR-1))

    I have a Suppliers table that contains a mixture of old and new style refs. When users input a new supplier, they are now to input only the new style refs, beginning

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Input Masks and data entry (2000 (9.0.4402 SR-1))

    You can advise the users to set the "Focus afer Move" option in the Keyboard tab of Tools | Options to End of Field.
    Or you could create code in the On Enter event of the text box to set the SelStart property of the text box to the length of the contents, so that the insertion point will be after the "CC".

  3. #3
    3 Star Lounger
    Join Date
    Nov 2003
    Location
    London, Gtr London, England
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Input Masks and data entry (2000 (9.0.4402 SR-1))

    Ah yes, both so simple. Have gone for the selstart, did look at that originally, but got confused as to how it worked. All I have had to do is put a line in after the .SetFocus that says "Me.SUPPLIERREF.SelStart = 2" and that places me at the insertion point after the CC (I see the count start as zero).

    Works fine!

    Thank you very much.

    Cheers,

    Niven <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •