Novice
Windows 10 
Access 2007
In a query I have data destined for print out in a report of letters. There is a field called FormSigned(Yes or No) in the query. If set to Yes, I want to hide another text field in the query/letters. If set to No, I want to show that field in the query/letters.
Could someone tell me how to set the query parameters, or tell me another way? Thanks
Nick Bygrave
VIP
Windows 10 Office 365
You can't hide a field in a query. You can chose to display or not a value but not actually hide the column as with multiple records you wouldn't see the ones you wanted.
You can easily hide a field in a report, the simple route is to use conditional formatting.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Access Developer
Windows 10 Access 2016
AFAIK you can't hide a field like that in the actual query but you could create a calculated field which only returns a value if the value of FormSigned is No.
In the report you could have a textbox control bound to the calculated field. The textbox can be set to allow it to shrink/expand as required to show the data therein.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Query to show records based on input field if another field is blank or has a value.
Show or hide a comment based on a field information
Posting Permissions
Reply With Quote