hi all!
I need to set precision to the left of decimal. For the number field i have to set the field precision such that the nos should be in a format as 0001,0002,0003------------------.9999.
Thanks
elanch
0
Newbie Poster
Recommended Answers
Jump to PostHi,
In the design view select the field and in the format property (in the lower part of the table design view) put 0000. This will show the number 1 as 0001 or 888 as 0888 noting that it is a matter of just format that means the number …
All 3 Replies
kb.net
0
Junior Poster
Hi,
In the design view select the field and in the format property (in the lower part of the table design view) put 0000. This will show the number 1 as 0001 or 888 as 0888 noting that it is a matter of just format that means the number will actually stay 1 or 88.
elanch
0
Newbie Poster
hi friend!
Thank u for u'r reply. I have tried your suggestion. But it is not working. when i enter a single digit no, the format is not changing.plz give me any other idea to do it.
thanks
kb.net
0
Junior Poster
Hi,
I have attached u a DB with one table to check it, if I wrongly understood you please clarify.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.