Access 2000 - hide/show object dependent on filed value

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

Guest

I am trying to put together a form that will give users an idea wether an question has one or more answers.
If one answer I wish to make visible an object (say a radio button called OneAns) if more than one answer I wish the button to remain invisible.
I have an integer field in my table with the number of solutions (nSols
When they click next form button, i hide the answers and the OneAns object, s
when the next record displays i wish to make this object visible IF the nSols=
Whenever i attempt this i get an unknown Function name error

Any help appreciate
John
 
In the form's Current event try

Me.OneAns.Visible = ([nSols]=1)

nSols=1 will return True or False, thereby supplying the appropriate answer
to Me.OneAns.Visible.

You may need to add a control to the form that is bound to nSols for this to
work. If so, just hide the control so that it doesn't show.

--
Wayne Morgan
Microsoft Access MVP


JW said:
I am trying to put together a form that will give users an idea wether an
Click to expand...
question has one or more answers.
If one answer I wish to make visible an object (say a radio button called
Click to expand...
OneAns) if more than one answer I wish the button to remain invisible.
 
Back
Top