show field on report only if YES

[gold]

I have a YES/NO field that I only want to show on my report if it is yes
I don't want anything to show if it's no

I'm sure this is easy to do but I haven't figured it out

thanks for any help

 

[fredg]

I have a YES/NO field that I only want to show on my report if it is yes
I don't want anything to show if it's no

I'm sure this is easy to do but I haven't figured it out

thanks for any help

Code the Report Detail Format event:
Me![CheckField].Visible = Me![CheckField]

 

[gold]

thanks for the quick answer
unfortunately it is beyond my ability/understanding

a more detailed explanation would be appreciated

I have a YES/NO field that I only want to show on my report if it is yes
I don't want anything to show if it's no

I'm sure this is easy to do but I haven't figured it out

thanks for any help

Code the Report Detail Format event:
Me![CheckField].Visible = Me![CheckField]

 

[gold]

sorta got what I wanted
made it a text field in the table and set the default value to null

thanks for the quick answer
unfortunately it is beyond my ability/understanding

a more detailed explanation would be appreciated

I have a YES/NO field that I only want to show on my report if it is yes
I don't want anything to show if it's no

I'm sure this is easy to do but I haven't figured it out

thanks for any help

Code the Report Detail Format event:
Me![CheckField].Visible = Me![CheckField]

 

[Pieter Wijnen]

Open the report in design view (properties page showing)
click on the Detail section
Goto the events flip of the properties page
select the on format event
click the builder button (...)
select code builder
write the code
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Me![CheckField].Visible = Me![CheckField] 'swap checkfield with the
name of the actual control

end sub

hth

Pieter

sorta got what I wanted
made it a text field in the table and set the default value to null

thanks for the quick answer
unfortunately it is beyond my ability/understanding

a more detailed explanation would be appreciated

On Mon, 2 Jan 2006 19:42:40 -0800, gold wrote:

I have a YES/NO field that I only want to show on my report if it is
yes
I don't want anything to show if it's no

I'm sure this is easy to do but I haven't figured it out

thanks for any help

Code the Report Detail Format event:
Me![CheckField].Visible = Me![CheckField]