CODEWITHSUNDEEP
vbams-access
Aaron Butler
Aaron Butler

Reputation: 21

Hiding text fields or buttons on a form by row rather than the whole form

I am stuck with a problem.
I have an Access database form with 3 text boxes in a row and I want to show or hide them based on if another field shows a 1, 2 or 3 or none if 0.

Currently I have them side by side and it looks a bit rubbish and would like them on.

The 3 fields are text1, text2 and text3.
The field it is looking at is completed.

Can anyone help?

Thanks

Aaron

Upvotes: 0

Views: 34

Answers (1)

Andre
Andre

Reputation: 27634

You can't toggle visiblity with Conditional Formatting.

But you can simply use a single text box, and set its back color with Conditional Formatting:

https://support.office.com/en-us/article/highlight-data-with-conditional-formatting-7f7c0bd4-7c37-421d-adad-a260125c8129

You can set the text dynamically in the underlying query, with IIf() or Switch()

Upvotes: 1

Related Questions