[AccessD] Access Export to Excel

Yes,
Use the format$ function: MyStr = Format(0032) ' Returns "0032".


Keith Williamson <kwilliam at ashlandnet.com> wrote:
Hi all;

I'm sure this is an easy one, but.....I have a report that I am trying to
export to Excel. One of the fields is a text field (example: "0032", as
text). When it exports to excel, it winds up truncating off the zeros, to
become "32", instead. I really need this field to remain "0032". Any
ideas?

Thanks in advance.

Keith E. Williamson
Ashland Equipment, Inc
phone # (410) 273-1856
fax # (410) 273-1859

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!