Hi,
I have a yes/no setting in the tables for the preferred column. I have a Query1 to get the data.
The Report derives data from the query1. Presently the report displays the checkbox irrespective of whether the value is true or false. How to ensure that the check box is displayed only if the column value is True/Yes else it is not displayed.
I've attached the sample db for immediate reference.
Thanks in advance.
Last edited by Ignorant; 03-06-2009 at 03:59 AM.
Reason: Title correction
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.preferred.Visible = Me.preferred
End Sub
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
How would I show my appreciation for helping me.
Is there some kind of Add Reputation etc...
Please pass it on by doing good deed for someone else.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)