problem with access not showing a column

[CapnOats]

Morning,

(Well, it is here at least.

Im designing a query which selects five fields to display as columns in the table view in access.

Problem is, one of the columns doesnt show, no matter if it's via a hand typed SQL statement or a design view made query. Strange, I know. I investigated further, only to find that when I open the table and view it, it no longer shows this field either, however a form that includes the field as a textbox does show the data.

Anyone got any ideas on what is going on?

Regards,
Mike

 

[GHolden]

Hi,

Have you tried viewing in datasheet view and doing right-click unhide columns (you need to click in the grey space, not on a cell)



There are two ways to write error-free programs; only the third one works.