Cannot view field in Table or Query - but can in form?? 1

[cariengon]

Wasn't sure if this should be in the table or query forum...

Anyway, we have a field that is a valid field and in the main table of our database. Users can view the contents of this field in the forms. But when we open the table or try to view the field in an adhoc query, it doesn't appear. Our first thought was that it was Unicode Suppression, but when we changed it from Yes to No, it didn't make a difference.

Anyone know what might be the cause of this and what a solution may be?

Thanks,
Carie

 

[Lilliabeth]

Did you try in the table Format > Unhide columns?

Is the show box unchecked in queries?

 

[cariengon]

Awesome!! The field was hidden. Someone must of inadvertantly selected the column then right clicked and selected "hide column" or something.

Thanks!