Unhide Query Field

[blkviper]

Ive set a formula within a query field to hidden, and i cant seem to get it to display again, i have gone to tools>options>view and checked view hidden objects but still nothing

any advice?

 

[jzwp22]

Run the query to get to the datasheet view. Find the line that separates the 2 current fields that are on either side of the hidden field. You should be able to hover the cursor over the line like in Excel until it changes to a vertical line with horizontal arrows then just click and drag to unhide the hidden field. My version (Access 2000) seemed to work better if I approached the line from the field to the right of the hidden field.

 

[RossWindows]

Also, I don't remember if this is for tables or queries, but I found that if you right-click on the top title bar of a query or table you should see the option to unhide the columns.