I believe you need to make a custom 'mask' to include all leading zeros. This
can be done under the 'format cell' option in Excel, I'm not sure how it's done
in Access.
Hope this helps.
[log in to unmask] wrote:
> Hi all,
>
>
> But somehow when I export the table into Text file (which is later FTPed to
> client site), I dont get those amount fields in leading zero format !! I
> have a export specification which shows that those 2 amount fields are
> Numeric and Long Integer, but am not able to locate any features or
> properties to have this in leading zero format. The specification however
> shows a option for leading zeroes in Dates being disabled but I do not have
> any dates in my files.
>
> I am using MSAccess 97. If anyone has come across on how this can be handled
> then your responses are duly appreciated. Thanks in advance.
>
> With Best Regards
> Raghu.
--
Larry Barnes
Director of I.T.
Mitek Corp.
602-438-4545 x1366
Phoenix, AZ 85040
Check Us Out !
http://www.mitekcorp.com