Results 1 to 2 of 2

Thread: Text box to display numeric

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    May 1999
    Location
    Littlehampton, W Sussex GB
    Posts
    203
    Simple question - whats the easiest way to display a numeric Access field -(double - standard format with 2 decimal places) in a text box like this 0.00? So that they all line up if there are no decimal places. At the moment they are coming out like 100. or 100.8 instead of 100.00 or 100.80.

    Also is there a quick way of validating text typed into a text box as numeric with 2 dec places?

  2. #2
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    1) use a format statement when populating the text box.

    2) you could check the amount being entered in the keypress event...

Posting Permissions

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



Click Here to Expand Forum to Full Width