Re formatting numbers (1 Viewer)

NickNeville

Registered User.
Local time
Today, 18:14
Joined
May 17, 2009
Messages
119
Would anyone be able to advise me on a formatting prob please.
In my table my field is a number which is showing zero's like 007
but when this is transferred to a list box on my form it shows only "7 "

Can this be shown as OO7 ?

Thanks in advance
Nick
 

RuralGuy

AWF VIP
Local time
Today, 12:14
Joined
Jul 2, 2005
Messages
13,826
You probably have a display format in the table. Use Format([YourNumber],"000") to display as 007.
 

NickNeville

Registered User.
Local time
Today, 18:14
Joined
May 17, 2009
Messages
119
Great I'l give it a try
Thanks a lot RG

rgds
Nick
 

neileg

AWF VIP
Local time
Today, 18:14
Joined
Dec 4, 2002
Messages
5,975
I prefer to apply the format at the last possible point, so usually in a form or report. That way you don't have issues with differing formats when you are manipulating data.
 

Users who are viewing this thread

Top Bottom