Fixed width export strips leading zeros...bad

[Andrew]

I run a fixed-width export based on a query, and the query looks like
this...

Clients.SSN, Clients.ClientID, ServiceEvents.SeviceDate,
CStr(Format([ServiceEvents.Unit],"0000")) AS Servs, "28" AS SETTING,
FROM Clients INNER JOIN ServiceEvents ON
Clients.AutoID=ServiceEvents.AutoID
WHERE ServiceEvents.Sub=False;

Now, this looks fine when I few the query, and the "Unit" field is 4
characters, with leading zeros. The export spec I use also assigns
the field 4 spaces. When I actually export though, there are no more
leading zeros, and everything is left justified. If this was a CSV,
I'd understand Access's stupid compulsion to strip these zeros, but
it's not. I've looked all over this group and have no been able to
find anything that works, plus it's all from nearly 4 years ago. Is
there anything new in Access 2002 that just hasn't been mentioned yet?

Thanks,
Andrew

[Andrew Weber]

I also wanted to add that the format of the "Unit" field is text.
"Andrew" <sp****@gnt.net> wrote in message
news:d8**************************@posting.google.c om...

I run a fixed-width export based on a query, and the query looks like
this...

Clients.SSN, Clients.ClientID, ServiceEvents.SeviceDate,
CStr(Format([ServiceEvents.Unit],"0000")) AS Servs, "28" AS SETTING,
FROM Clients INNER JOIN ServiceEvents ON
Clients.AutoID=ServiceEvents.AutoID
WHERE ServiceEvents.Sub=False;

Now, this looks fine when I few the query, and the "Unit" field is 4
characters, with leading zeros. The export spec I use also assigns
the field 4 spaces. When I actually export though, there are no more
leading zeros, and everything is left justified. If this was a CSV,
I'd understand Access's stupid compulsion to strip these zeros, but
it's not. I've looked all over this group and have no been able to
find anything that works, plus it's all from nearly 4 years ago. Is
there anything new in Access 2002 that just hasn't been mentioned yet?

Thanks,
Andrew