If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fields not showing up in columns
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. |
#2
|
|||
|
|||
Fields not showing up in columns
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? -- Build a little, test a little. "Charlotte Hinger" wrote: 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. |
#3
|
|||
|
|||
Fields not showing up in columns
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. "KARL DEWEY" wrote: 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? -- Build a little, test a little. "Charlotte Hinger" wrote: 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. |
#4
|
|||
|
|||
Fields not showing up in columns
On Tue, 20 Apr 2010 19:48:01 -0700, Charlotte Hinger
wrote: 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. 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. "KARL DEWEY" wrote: 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? -- Build a little, test a little. "Charlotte Hinger" wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|