Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    23

    Unanswered: setting the length of textbox field

    Hi All,

    I have got another doubt with Forms. Can we set the length of the textbox field using any of the parameters in property sheet. I didnot find any!.

    For Example: I have a textBox filed named "seconds" which should accept 3 digit numbers only. I have set the datatype as double while creating the table.

    Also Can we do this with setting any validation rule for this field.

    Please help me out in this regard.

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    If you've set the data type to a number, you can set the validation in table design not to accept anything above a certain number.

  3. #3
    Join Date
    Jun 2009
    Posts
    23
    I have set the data type to a number!. and also the field Size is set to double. Can you tell me the syntax on How to set the validation.

  4. #4
    Join Date
    Jun 2009
    Posts
    23
    I'm able to figure it out. Thanks for your help.

Posting Permissions

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