brucemc777
Member
- Local time
- Today, 01:34
- Joined
- Nov 1, 2012
- Messages
- 88
Thank you for considering my confusion!
I can't believe this is so hard, so that probably means there is a very simple solution i am too tunnel-focused to see. I am re-learning Access after a long time away, living in the land of Excel for the past decade or so.
In the simplest example, let's say we have our form frmForm. On it are five controls - four textboxes bound to a table and one command button. Each time a textbox is updated or changed i want to check the other three. If all four have contents; i.e., <>"" (or <> vbNullString if Access uses that also, IsNull does not work for this) i want to make the command button visible, but if any are blank, then not visible.
To check the text property of each would be ideal, but i get an error message that i cannot check that property unless that control has focus, and it seems a little absurd for me to write a routine that sets focus on each control, checks it, then moves on to the next just to accomplish this - not that it is hard to do, but i've got to be missing something obvious here...
Thank you for all your help!
I can't believe this is so hard, so that probably means there is a very simple solution i am too tunnel-focused to see. I am re-learning Access after a long time away, living in the land of Excel for the past decade or so.
In the simplest example, let's say we have our form frmForm. On it are five controls - four textboxes bound to a table and one command button. Each time a textbox is updated or changed i want to check the other three. If all four have contents; i.e., <>"" (or <> vbNullString if Access uses that also, IsNull does not work for this) i want to make the command button visible, but if any are blank, then not visible.
To check the text property of each would be ideal, but i get an error message that i cannot check that property unless that control has focus, and it seems a little absurd for me to write a routine that sets focus on each control, checks it, then moves on to the next just to accomplish this - not that it is hard to do, but i've got to be missing something obvious here...
Thank you for all your help!