no period "." in field names? what to do?

[Danny]

I have to make a database that will export to a tab delimited file, but the
requirements are
a field name with a . in the field so [item no.]

Is it true access will not allow this?
If not, how can I get around this?

Thanks

[Rick Brandt]

"Danny" <da********@hotmail.com> wrote in message
news:lU***********************@news4.srv.hcvlny.cv .net...

I have to make a database that will export to a tab delimited file, but the requirements are
a field name with a . in the field so [item no.]

Is it true access will not allow this?
If not, how can I get around this?

Try assigning a caption property to the field. These allow periods but I'm
not sure if the actual field name is used in an export or if the caption
will be used. If the export uses the caption then problem solved.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Danny]

I tried this and it does not work. But if I check the 'save formatted' when
I export, it does maintaint the "." but puts all these dashes in the export
file.

I guess I can just export the file without field names and keep a header
string and append this file to the header string in code and create a new
file.
What a pain!!

Thanks

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:c6************@ID-98015.news.uni-berlin.de...

"Danny" <da********@hotmail.com> wrote in message
news:lU***********************@news4.srv.hcvlny.cv .net...

I have to make a database that will export to a tab delimited file, but the

requirements are
a field name with a . in the field so [item no.]

Is it true access will not allow this?
If not, how can I get around this?

Try assigning a caption property to the field. These allow periods but

I'm not sure if the actual field name is used in an export or if the caption
will be used. If the export uses the caption then problem solved.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com