Snowflake68
Registered User.
- Local time
- Today, 03:46
- Joined
- May 28, 2014
- Messages
- 452
I have a number field and that I want to display zeros on a datasheet form but also show the commas for the thousands. Eg. 2,500
I formatted the text box on the datasheet form to #,### but this doesnt show the zeros. How do I format it so that also show the zeros.
row 1 value = 2,500
row 2 value = 0
row 1 shows correctly but row 2 shows nothing
I formatted the text box on the datasheet form to #,### but this doesnt show the zeros. How do I format it so that also show the zeros.
row 1 value = 2,500
row 2 value = 0
row 1 shows correctly but row 2 shows nothing
Last edited: