Show/hide a query field from a checkbox in a form instead of the checkbox in query design mode

[MorganM]

I would like to have a checkbox in a form that can show/hide a query field instead of using the checkbox in query design mode. Is this possible to do without getting too complex with code?

[June7]

Depends what you mean by 'too complex'.

Code behind form can hide/unhide controls but this doesn't work nice if form is in Continuous or Datasheet view.

A textbox or combobox can have Conditional Formatting that will enable/disable it depending on condition. In this case the condition could be the value of another control, such as a checkbox.