Data Type For Fields That Can Start With 0 (1 Viewer)

[johnedm]

Ok,

So after finishing my database with mail merges I found out that I identified a few fields as number fields but these fields may contain numbers that start with 0 and I need to preserve that.

I believe the right step is to make those fields text fields. This preserves my 0 for me but gives me other problems. My question is if that is the only way to retain the lead 0 in the data?

If it is then my problem then becomes a mail merge problem.

I am mail merging to a specific form and need the data to fit into specific boxes but I am unable to format the text with a switch. I can format the data when it is a number by using /# ### ## ####. This works just fine for me
but I am unable to format it when it is text with a switch. I basically need to put spaces in between the text fields so i can make it fit so instead of 012345678, I need it look like 0 1 2 3 4 5 6 7 8 9 in the word document.
I cant seem to fins anything on formatting text switches for spacing.


Thanks!

 

[599CD.com]

Have you tried leaving the data as a number, but formatting the data as a string in a query, and then using that query to do your mail merge?

Richard Rost
599CD.com