Results 1 to 2 of 2
  1. #1
    GraemeG is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    152

    Textbox and numbers

    Hello.

    I have textboxes which are formatted to text (I want to keep it this way, along with it corrupts data if I now change it)

    Is there a way on my form and VB to restrict what response the user enters.
    I.e Just a whole number with no decimal places or other text or symbols?

    Any help much appreciated.


    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can turn on Key Preview for the Form and then use the KeyPress event of the Control to eliminate all but the numeric values.

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

Similar Threads

  1. numbers
    By Balen in forum Access
    Replies: 1
    Last Post: 08-17-2010, 05:16 PM
  2. Replies: 2
    Last Post: 08-12-2010, 11:21 PM
  3. Random numbers
    By Gator777 in forum Access
    Replies: 3
    Last Post: 08-12-2009, 10:04 AM
  4. Rounded Numbers
    By TundraMonkey in forum Access
    Replies: 3
    Last Post: 08-11-2009, 12:19 PM
  5. Set Numbers equal to each other
    By ygu3 in forum Access
    Replies: 1
    Last Post: 07-16-2009, 07:34 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