Results 1 to 2 of 2
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528

    text box in form

    Hello all
    I have a component of a text box on the form, in some cases, is the introduction of a number with a decimal point in it and sometimes enter text.


    How can I make the text box to comply with it
    Thank you

  2. #2
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407
    set the type to text, if you then need to do any math with the entry you can convert it to a number with the val function.
    if the field is bound to a table, your table field type must also be text to accept both

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 03-22-2013, 06:37 AM
  2. Replies: 3
    Last Post: 12-22-2012, 05:33 PM
  3. Replies: 7
    Last Post: 10-17-2012, 11:59 AM
  4. Replies: 2
    Last Post: 03-01-2012, 12:21 PM
  5. Replies: 15
    Last Post: 09-18-2010, 01:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums