C clive2002 Registered User. Local time Today, 21:25 Joined Apr 21, 2002 Messages 90 Jun 26, 2007 #1 Not having a good day with number formating. How can i display (,) seperators in a text box which update as a user enters a value, having users enter high values and im concerned about typo's.
Not having a good day with number formating. How can i display (,) seperators in a text box which update as a user enters a value, having users enter high values and im concerned about typo's.
Dennisk AWF VIP Local time Today, 21:25 Joined Jul 22, 2004 Messages 1,649 Jun 27, 2007 #2 do you want users to enter values seperated by ',' if so then you probally need to normalise your database tables. this is basically a repeating group and each entry should be in a seperate row.
do you want users to enter values seperated by ',' if so then you probally need to normalise your database tables. this is basically a repeating group and each entry should be in a seperate row.
doco Power User Local time Today, 13:25 Joined Feb 14, 2007 Messages 482 Jun 27, 2007 #3 In the properties dialog for the textbox control in question under 'Format' type 'Standard' EG. '123456789' then becomes 123,456,789.00. If you do not want two decimals then under 'Decimal Places' in the dialog put '0'
In the properties dialog for the textbox control in question under 'Format' type 'Standard' EG. '123456789' then becomes 123,456,789.00. If you do not want two decimals then under 'Decimal Places' in the dialog put '0'
