Fields not showing up in columns

[Charlotte Hinger]

I have a field titled PageNumber in a table that is not showing up in my
columns, although it is checked in the design view and is not hidden. On the
form view I have access to this field and it has all the entries, which would
indicate that nothing has been accidentally deleted.

What's happened, and how can I fix this so the page number column shows up
in the table.

 

[KARL DEWEY]

The terms you are using and the way you use them are confusing to me.

Access has 'fields' in table. Those fields are displayed in columns.

When you say 'I have a field titled PageNumber in a table that is not
showing up in my columns,' does that mean that data is not being displayed or
that the field is not shown. And where is it not seen - in a report, form,
or when the table is viewed in datasheet view?

 

[Charlotte Hinger]

Karl, my apology for being so late in replying. The reply notification did
not show up in my email program.

Sorry for the lack of clarity. I meant I can't get a field to display in a
column. Unhide is checked and the data is there. I can access it the field
and the data through the "form" view, but I can't create a column with this
field. The data is there in the report view also.

 

[John W. Vinson]

On Tue, 20 Apr 2010 19:48:01 -0700, Charlotte Hinger

It's possible that Access is considering PageNumber to be a reserved word. Do
you get the same problem if you open the table in design view and change the
fieldname to PageNo?

Note that the Discussions webpage notification button has been broken for
ages, and Microsoft shows no inclination to fix it.