hide a control if conditions = true

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

a have a field in a report. that it's value is "n"
by default is non visible. visible = no
and i want to show a "n" when a conditions give up.
example.

products | amount | prices | (fieds yes/no hidden)

if [fields yes/no] is selected i want to show this (an asterisc)

example.
products | amount | prices | "n"
 
(fieds yes/no hidden)

what does the above mean? that the field is a Yes/No (checkbox) field? and
that the control bound to the field has its' Visible property set to No?
if [fields yes/no] is selected i want to show this (an asterisc)
Click to expand...

if the Yes/No field is selected? you can't select, or set the focus on, a
control in a report - only in a form. are you trying to show or hide a
checkbox control in the report? or show/hide another control, based on the
value in a checkbox control or Yes/No field?

i have a feeling that what you're trying to do is not difficult, but you
need to explain the scenario clearly - or else any help we give you is just
trying to guess at the situation.


Joel John said:
a have a field in a report. that it's value is "n"
by default is non visible. visible = no
and i want to show a "n" when a conditions give up.
example.

products | amount | prices | (fieds yes/no hidden)

if [fields yes/no] is selected i want to show this (an asterisc)

example.
products | amount | prices | "n"
Click to expand...
 
Not sure if I understand completely, but you could, instead of making the
field visible/invisible, make it null/not null depending on the value of the
related field. This way, it will be empty. You could put something like this
in the field's ControlSource:

=Iif([ThisField] = "n",[ThisField],null)

If ThisField is "n", then it will display, if not, it will be null, which
will look the same as invisible. ThisField must exist in the report's
RecordSource but not be the name of the field that has this in it.
 
Back
Top