Table Field Name Size

[BLD]

All,

Is there any way to increase the Default size of a Table Field Name of 64 characters in Access 2016?

I know this is the default but was hopeful it could be done somehow or a work around other than limiting the import field names I am working with.

Thanks,

BLD

 

[isladogs]

64 characters is the maximum allowed for object names in Access.
See https://support.office.com/en-gb/article/Access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

 

[JHB]

..
Is there any way to increase the Default size of a Table Field Name of 64 characters in Access 2016?
..

Not directly, but you can use the Field's Caption property.

 

[The_Doc_Man]

That's a pretty good suggestion, JHB.

 

[Cronk]

I wonder why anyone would want to have a table name that long. I try to name tables meaningfully and as short as possible. I've maybe had some join tables as long as into the teens but nowhere near 64.

 

[CJ_London]

column heading is probably from excel -something like


Balance Friday before last adjusted for fish, chips and rock'n'roll but not Baywatch or Dallas

 

[The_Doc_Man]

Probably imported from something else that includes a really verbose column title. I've been known to be a BIT verbose... but 64 characters as a column/field name? Sheesh!

 

[BLD]

To all,

Thanks for your comments. Yes it is not normalized. I am working with an excel questionnaire of about 50 questions and I am trying to compile all of the answers. I would have to write too many formulas in excel and wanted to move the data into access. I am thinking about creating multiple tables and maybe create some kind of lookup table with new field names. I do like the idea of the caption property.

Many thanks!