Report checkbox

[nirie1]

I have created a database that has a yes/no checkbox. I want the
checkbox to only show in the report when there is a yes value. I need
the checkbox for the form so I dont want to get rid of it. If for some
reason I have to change the checkbox to a text box will the data be
deleted? I am not really good at access. I am self taught.

 

[fredg]

I have created a database that has a yes/no checkbox. I want the
checkbox to only show in the report when there is a yes value. I need
the checkbox for the form so I dont want to get rid of it. If for some
reason I have to change the checkbox to a text box will the data be
deleted? I am not really good at access. I am self taught.

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

 

[Marshall Barton]

I have created a database that has a yes/no checkbox. I want the
checkbox to only show in the report when there is a yes value. I need
the checkbox for the form so I dont want to get rid of it. If for some
reason I have to change the checkbox to a text box will the data be
deleted?

The format of how the data is displayed in the table has
nothing to do with how it is stored in the table or
displayed in the form or report. They could all be
different if that's what you wanted.

To make a control invisible, use VBA code in the report
section's Format event procedure. In this case, I think all
you need is this knid of thing:
Me.checkboxname.Visible = Me.checkboxname

You may not like the way a check box looks on a report or
you may want to shrink the check box's space when it is
hidden. If so, come on back with more details.