My field has disappeared

[Deborah]

Something has happened to one of the fields in my table.
The field "Type" is in my table design. It is in my
query, but when you pull up the records for the table the
field is not there. Please help.....

 

[Tim Ferguson]

The field "Type" is in my table design.

The word "Type" is a reserved word in just about every programming platform
imaginable, including VBA, DOS, SQL and so on. If you really cannot think
of a better description of your column, then you'll have to surround it
with [braces] everywhere you use it, but it's still a bug waiting to
happen.

Similar applies to words like Date, Time, Number, Order and so on.

HTH


Tim F

 

[Duane Hookom]

I expect you (or someone) has simply set teh field width very narrow in
datasheet view. Consider swiping across all your column headings and
double-click between a couple columns to resize.

 

[Van T. Dinh]

1. In the DesignView of the Query, make sure the "Show" checkbox is ticked
for the column "Type".

2. If the above is ticked and the column "Type" is still not visible, it
might have been hidden by accident (e.g. column width reduced to zero or too
small that you can't see).

Use the Menu Format / Unhide Columns ... to unhide the Column if it is
hidden (width = 0). If the column width is small but not zero (unhide won't
work in this case), inspect the Field name row of the datasheet for strange
marker / divider between columns. If you see a strange one (it is actually
2 markers close together), try dragging one of the markers to the right to
increase the width of the column.

HTH
Van T. Dinh
MVP (Access)

 

[Deborah]

I have tried these suggestions. The field appears to NOT
be hidden of to small to see. Any other suggestions. I
have about 4000 records in this table and can stand the
thought of having to recreate.

-----Original Message-----

The field "Type" is in my table design.

The word "Type" is a reserved word in just about every programming platform
imaginable, including VBA, DOS, SQL and so on. If you really cannot think
of a better description of your column, then you'll have to surround it
with [braces] everywhere you use it, but it's still a bug waiting to
happen.

Similar applies to words like Date, Time, Number, Order and so on.

HTH


Tim F

.

 

[Deborah]

I have tried these suggestions. The field appears to NOT
be hidden of to small to see. Any other suggestions. I
have about 4000 records in this table and can stand the
thought of having to recreate.

-----Original Message-----

The field "Type" is in my table design.

The word "Type" is a reserved word in just about every programming platform
imaginable, including VBA, DOS, SQL and so on. If you really cannot think
of a better description of your column, then you'll have to surround it
with [braces] everywhere you use it, but it's still a bug waiting to
happen.

Similar applies to words like Date, Time, Number, Order and so on.

HTH


Tim F

.

 

[Tim Ferguson]

Any other suggestions. I
have about 4000 records in this table and can stand the
thought of having to recreate.

If you can see the field in the Table Design grid, and it appears in the
model table in the query designer, then it's there. Just to convince
yourself: create a new query; cancel the "Show Table" dialog; select View |
SQL; and enter the following

SELECT ALL [Type] AS MyHiddenField
FROM [MyTable]


(exactly, except for inserting the correct table name -- keep the
[brackets] ) and then select View ! Datasheet. One of two things can
happen: you'll get an input box asking for a value of [Type]; or it will
show a single column of values.

If the column remains hidden, then you can (a) forget about it -- who cares
about datasheets anyway? -- or (b) recreate a new table with all the same
field descriptions and append the records from the old table into it.

Just one thought: please tell me that the [Type] column is not a LookUp
type field?

HTH


Tim F