Results 1 to 2 of 2
  1. 01-21-2009, 05:02 AM #1
    pEkvo
    pEkvo is offline Novice
    Join Date
    Jan 2009
    Posts
    1

    fieldsize

    I want to be able to set a lower and an upper limit when entering characters for a text field. The one field property I can think of is 'fieldsize' but this just sets the upper limit.

    If, say, I have a destination code and I want to make sure it has between 3 and 6 characters, how do I make this happen? I've thought of a validation rule but this pertains solely to the content of the field, right?



    Thanks
    pEkvo
    Reply With Quote Reply With Quote
  2. 01-26-2009, 06:34 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You would verify your input in the BeforeUpdate event of the control on the input form.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums