In the Lostfocus() of the textbox, do the following: Just remember that the field will then be a character field
cValue=Alltrim(Transform(Val(This.Value))) This.Value=cValue * return Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of wtc Sent: 09 August 2010 08:01 To: [email protected] Subject: Numeric format in textbox In my form got a textbox field to store diameter size value with the input format "999.99". How do I display the value in the same textbox field with the following result after user input the value: e.g. value input: display result in following format (hide the 0 decimal point) 12.86 12.86 15.00 15 18.30 18.3 I tried to use @Z or @Z99.ZZ in the format field, but not what i want. Can anyone point me to an correct format? Thank you. wtc [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
