Invisable Field

M

MO

One of the fields I created in my main table does not show up on the
datasheet view. it is there in the design view. It is there when creating
queries and forms, but it does not show up on the main table. Any ideas as
to why?
 
S

Sprinks

I suspect the column width has been inadvertently dragged to where it's no
longer visible. Click on the first column and drag to the last, then
double-click on the column separator between any two of the columns, and see
if it doesn't return.

Hope that helps.
Sprinks
 
6

'69 Camaro

Hi.
Any ideas as
to why?
Click to expand...

The column may be hidden, or the column may be squeezed between two other
columns, so that the column to the right is overlapping the missing column.

Right-click on the Datasheet View Title bar and select the "Unhide
Columns..." item on the pop-up menu to open the "Unhide Columns" dialog
window. Make sure that all column names have a check box marked, then select
the "Close" button. Any columns that you marked will now be visible with the
others.

If this doesn't help, then wherever you think the column should be in the
Datasheet View, try to drag the borders of the column to the right to expand
the squeezed column.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.
 
M

MO

Thank you so much...it worked...somehow it was not checked. Maybe you know
about the other question I posted yesterday. Our database is on a shared
folder that our entire department has access to. We used to all be able to
get into the database at the same time (as long as no one was making
formatting changes), but since we moved to a new server, only one of us can
open it at a time. We all still have access to it, but only one at a time.
I checked the settings and it is set up as a shared database, not exclusive.
Any ideas?
 
Top