Field Headers in a Tbl Made by a Qry

[liamrowan]

I have a table that is created by a MakeTable qry. After the table has been created, one of the field names is in lowercase. If I change that field name to all uppercase in Design View of the table, save and close, the field name reverts back to lowercase when the table is reopened. If I change the field name to uppercase when the table is in Datasheet View, save and close, the uppercase format "sticks" and is not reset to lowercase when reopened. Why would a change of case not be possible when made in Design View but be possible in Datasheet View?

Thx for insight.

Wm

 

[Beetle]

Could be one of the many bugs related to having Name AutoCorrect enabled in your database options. See here for more info.

 

[liamrowan]

Thx for this theory, which certainly made sense. However, after disabling Name AutoCorrect, the field name still changes to lowercase if it is changed in Design View, and the change still "sticks" if made in Table View.

I also tried saving the database, closing, reopening after the disable, but that didn't work either.