Some fileds do not show in the table

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

I have a table defined 30 fields, however, if I open it inside Access it
onlys shows 20 fields.
Is there any Show/Hide flag set?
 
Alan

How are you "opening" it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi,

I Run the Access, open the .mdb file, select the table, click Open.
 
Alan

Your table probably has some of its columns set to width = 0 (hidden). Have
you tried Format | Column ... to unhide those?

And unless you are in a design phase, you probably don't need to be working
directly in the tables. You certainly don't want to let users be working
directly in the tables!

Instead, what happens if you create a new query, based on that table? You
should be able to see ALL the columns/fields.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link table field format puzzle 1
Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0
OLE-objects (foto's) don't show on forms 1
oracle sql plus - modified table column - not showing in Access 1
how do you show all fields from linked data? only shows first one 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Find table used in form 3
Make table query only runs from design view. 3

Back
Top