Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table names being shortened in db window, list view

Status
Not open for further replies.

VickyC

Technical User
Sep 25, 2010
206
CA
hi to all.

I have thousands of reference tables with names like tRef__nOT_4_sOTX_12_v23. These are stored in multiple MS Access 2002 mdb files.

Recently, a problem has arisen, and I think it may have happened when I switched from Windows 7 to Windows 10 (not sure).

Here's the problem: The table names (in the db window, list view, have been truncated. The example above looks like tRef__nOT_4_sOTX_12... The name is still there, and the tables still function properly, but I now have MULTIPLE tables that ALL look like tRef__nOT_4_sOTX_12...

Is there any way to allow the full names to be seen?

For what its worth, NOT ALL table name's have been shortened. Some of the older ones that I haven't accessed are much longer. Maybe a Registry setting?
 
If you can't change the table names, create queries and name them with shortened versions of the names. Don't put any criterion in the queries, just use them to build off so you can see the names.
 
Can you not widen the viewport?

access_cybubf.png


Click, hold, drag.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top