Make field not visible

[lmhudson]

I have a form that I want to hide one of the fields if certain criteria is not met, how can I do this plz

On my main form I have a field which shows a users "Level" (Number) and when they press the button to open the form I want one of the fields hiding if the level is say < 50

I'm comfortable with the if statement to get the true / false answer but how to then hide the field.
Field visible by default

If answer = true
?? me.[fieldinquestion].visible = false ??
?? me.[fieldinquestion].visible = true ??

Both seem to hide the field, what's wrong

 

[Joe4]

Where exactly are you placing this code? In some event procedure?

Can you post your entire code exactly as you have it?

 

[CT Witter]

You will need to modify to something like:

If Me.txtAnswer = True Then
Me.fieldinquestion.Visible = True
Else
Me.fieldinquestion.Visible = False
End If

Also, I would set [fieldinquestion] visible properties to false (right-click, properties, then scroll to visible =no)

That way the field is normally "hidden" and won't be seen if something else goes wrong in your code.

HTH,
CT

 

[lmhudson]

Have sorted it (got my criteria the wrong way round so was always returning false), but thanks for the help anyway