By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

in a query how to you hide a column if it is null

P: 5
in microsoft 2003 access I have a guery. One of the columns is null how do i hide that column
Aug 10 '10 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,240
You cannot hide a column in a query. You can hide objects on forms and reports, but not in a query.

Jim
Aug 11 '10 #2

Jerry Maiapu
100+
P: 259
I.E.
Expand|Select|Wrap|Line Numbers
  1. 1.You can make columns(fields) of
  2.  queries not to appear on forms or reports by deleting
  3.  the field on the form 
  4.  
  5. 2.set Field's visible property to No within a form where the
  6. Forms' recordsource is the query; so that it's invisible.
  7.  
  8. 3. You can delete the column within the query
  9.  
  10. 4You can untick the column within the query so 
  11. that it does not appear when run..
Aug 13 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.