Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-21-2009, 09:07 PM   #1
NickNeville
Newly Registered User
 
Join Date: May 2009
Posts: 119
Thanks: 1
Thanked 0 Times in 0 Posts
NickNeville is on a distinguished road
Re formatting numbers

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

NickNeville is offline   Reply With Quote
Old 05-22-2009, 03:44 AM   #2
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,821
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Re: Re formatting numbers

You probably have a display format in the table. Use Format([YourNumber],"000") to display as 007.
__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline   Reply With Quote
Old 05-22-2009, 04:21 AM   #3
NickNeville
Newly Registered User
 
Join Date: May 2009
Posts: 119
Thanks: 1
Thanked 0 Times in 0 Posts
NickNeville is on a distinguished road
Re: Re formatting numbers

Great I'l give it a try
Thanks a lot RG

rgds
Nick

NickNeville is offline   Reply With Quote
Old 05-26-2009, 04:34 AM   #4
neileg
AWF VIP
 
neileg's Avatar
 
Join Date: Dec 2002
Location: Newcastle, England
Posts: 5,975
Thanks: 0
Thanked 8 Times in 8 Posts
neileg has a spectacular aura about neileg has a spectacular aura about
Re: Re formatting numbers

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.

__________________
You can't always get what you want, but if you try sometimes you may just get what you need - Rolling Stones

Cheers, Neil
neileg is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting telephone numbers RexesOperator Reports 6 11-02-2008 09:35 PM
Formatting numbers as addresses fendermate Tables 9 03-26-2008 07:39 PM
Formatting numbers VegaLA Queries 1 10-25-2006 10:23 AM
Formatting Numbers xDamian General 2 02-12-2004 01:52 AM
Formatting text box numbers PaulSpell Forms 1 11-18-2002 01:52 PM




All times are GMT -8. The time now is 08:52 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World