C
Christopher Deel
This is regarding "online forms" using form fields and a protected section.
I was very glad to find the article "The best way to select a form field
using VBA" on the MVP website, because it did fix my "not selecting the
whole field" and "screen jumping" issues when used in a "field
navigation"-type OnExit macro to change the default order of fields when
"tabbing" through the form.
However I've noticed that when a field is selected this way--although it
does appear to select the whole field--when I start to type, the first
character I enter does not go into the field.
(i.e. the text only start to fill in the form field from the second
character typed.) It can be a problem if you're filling in a form quickly
and don't notice that the first letter you typed didn't "take".
I'm no expert at VBA, but could this be something to do with operating on
the "Range" instead of just selecting the field? Has anyone observed this
behavior or know any solution for it?
I was very glad to find the article "The best way to select a form field
using VBA" on the MVP website, because it did fix my "not selecting the
whole field" and "screen jumping" issues when used in a "field
navigation"-type OnExit macro to change the default order of fields when
"tabbing" through the form.
However I've noticed that when a field is selected this way--although it
does appear to select the whole field--when I start to type, the first
character I enter does not go into the field.
(i.e. the text only start to fill in the form field from the second
character typed.) It can be a problem if you're filling in a form quickly
and don't notice that the first letter you typed didn't "take".
I'm no expert at VBA, but could this be something to do with operating on
the "Range" instead of just selecting the field? Has anyone observed this
behavior or know any solution for it?