Left zero fill on export of field

[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

 

[Terry Kreft]

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

 

[Allen Browne]

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.

 

[Terry Kreft]

LOL, synchronisity.

--
Terry Kreft
MVP Microsoft Access

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.

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

 

[Allen Browne]

We've both been doing this too long, Terry!