Thread: Zeros at the beginning of a number in a number field
View Single Post
  #2  
Old October 21st, 2008, 11:31 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
  
Posts: 10,767
Default Zeros at the beginning of a number in a number field
Number do not have leading zeros. You need a text field.
Another thing, number cannot have a dash in it.
--
KARL DEWEY
Build a little - Test a little


"Iram" wrote:

How do I get a field in a table to hold zeros before the number, example
083121555-01
I have tried double, single, integer and non hold the 0 at the beginning.

Can you help?


Iram/mcp