Left zero fill on export of field

  • Thread starter Thread starter jubejoie
  • Start date Start date
J

jubejoie

I see on my table the left zero fill in a field defined as
number 5 in length and format = 00000. When data entering
a 1 in this field the table will look like this "00001",
WHICH IS WHAT I WANT. But when I export the table, fixed
length , the leading left zeros disapear!

How do I get my zeros to come export out!?
thanks
 
1) Create a query based on the table
2) In the query grid, in place of the field you want formatting put
Format([YourFieldNameHere], "00000")

3) Save the query
4) Export the query
 
1. Create a query.

2. In the Field row, enter:
Format([MyField], "00000")
where "MyField" represents the name of your field.

3. Export the query.
 
LOL, synchronisity.

--
Terry Kreft
MVP Microsoft Access


Allen Browne said:
1. Create a query.

2. In the Field row, enter:
Format([MyField], "00000")
where "MyField" represents the name of your field.

3. Export the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

[email protected] said:
I see on my table the left zero fill in a field defined as
number 5 in length and format = 00000. When data entering
a 1 in this field the table will look like this "00001",
WHICH IS WHAT I WANT. But when I export the table, fixed
length , the leading left zeros disapear!

How do I get my zeros to come export out!?
thanks
Click to expand...
Click to expand...
 
Back
Top