Make column Invisble-Report-Access 2003

**Ignorant** · 03-06-2009, 03:55 AM

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.

**HiTechCoach** · 03-06-2009, 09:36 AM

Try this:

Code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Me.preferred.Visible = Me.preferred

End Sub

**Ignorant** · 03-07-2009, 01:02 AM

you are great man

but i didn't get the
Code:

.Invisble

in the intellisense. Is it somekind of invisible property?

**Ignorant** · 03-07-2009, 01:07 AM

How would I show my appreciation for helping me.
Is there some kind of Add Reputation etc...

**HiTechCoach** · 03-07-2009, 01:43 AM

Originally Posted by Ignorant

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.

**Ignorant** · 03-07-2009, 01:55 AM

Originally Posted by HiTechCoach

Please pass it on by doing good deed for someone else.

so magnanimous of you

but do you mean there is no system of giving Reputation points in this forums.

**HiTechCoach** · 03-08-2009, 02:26 AM

There is not a way that I know of in this forum.

Thread: Make column Invisble-Report-Access 2003

Thread Tools

Display

Make column Invisble-Report-Access 2003

Posting Permissions