how do I create (or rename would be OK too) a Field whose name ends with a blank?

[DocMyles]

(I'm a newbie here so please forgive me if I my posting inadvertently breaks a protocol...)

I have a very unusual situation where I need the name of a field in an Access table to end with a blank (i.e. space). I tried doing it trivially while in Design View but no dice. I tried it through some SQL along the lines of the following pseudo code

Select [old table].[Address] as [Address2 ], [old table].*
Into [new table]
From [old table]

but the new field's name "Address2 " lost the final space.



A third try was through some syntax for an Alter Table statement to add or modify a field. It didn't pan out.

Any thoughts?

Thanks, in advance, for any help.

[NTC]

one can add a space via syntax: & " "

applied either during the user action in a form during data entry...or mass applied in an update query

[John_G]

I don't think you can do that; trailing spaces tend to mean nothing to Access.

Why do you want the name to end with a space?