Format for imported text field

[Clandon]

I am importing a txt file with a field into a table that could be less than the desired 10 character length. I would like the field to import as 10 character with leading zeros if it is less than 10. I want to keep it as a text field instead of numeric.

I am able to format the field in a query using Format([field],"0000000000&quot.

I have tried "0000000000" and @@@@@@@@@@ in the format of the table, and an input mask in the table design, but they are not working.

Any suggestion is appreciated.

 

[jdegeorge]

I tried Format([Field],"0000000000&quot and it worked just fine.

Are you sure that [Field] is defined as a text field?

Jim DeGeorge

 

[Clandon]

Hi Jim.

Are you formatting it in a query or in the table design format box on the general tab in desing view for the table?

The query works for me, but I was looking for a format to hold the import field so I wouldn't have to create an additional formatting query for linking purposes.

Any other suggestions?

Cheryl

 

[jdegeorge]

Ah. No I didn't, just the query grid. But I just tried to set a table's field to that format and it didn't work.

I do something similar with leading characters and I choose to do it right in the query. Sorry.

Jim DeGeorge

 

[Clandon]

Thanks for the help anyhow. If you happen to figure it out, please let me know.

Cheryl