[AccessD] I just gotta vent

Hi John

Further to Shamil's comments, I see nothing new here. One record is needed
for the form to be operational, if not an existing then at least a new
record.

If you wish a permanently available Text property, go with Visual Basic
(just kidding) or .Net.
To check which (or if a) control has the focus, use Me.ActiveControl.

And InputMask has always been very "stiff". I think I can count on one hand
the cases where I have used it.

Finally, challenges is what keep you young!

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af John Colby
Sendt: 12. december 2013 20:44
Til: accessd at databaseadvisors.com
Emne: [AccessD] I just gotta vent

Trying to do some search kind of stuff using a text box to allow a user to
type in a loan number and pull all loan numbers LIKE what they typed in.
The text box is in the header of the form.

1)  The text box CAN ACCEPT the focus but Access refuses to believe that it
has the focus IF there is no data in the form.
2) TxtBox.Text is not available unless the control has the focus.
3) ONLY txtbox.Text has the actual value in the control for each character
typed in.  TxtBox.Value is only updated when the control loses the focus.
4) So at least one record has to be displayed in the form BEFORE the search
can be used.

The above is a bug reported clear back in the 2000 time frame (or I see
references to it in Google from then)

5) Did you know that the MASK control ACTUALLY PLACES the underscore
character in the control for every mask character?  IOW %%%%% causes _____
to actually be placed in the control.  So now Len(txtBox.Text) is
5 even though the user hasn't typed anything into the control.

Could it possible get any uglier?

Stay tuned for more ugly crap.  BUT... we have pretty tool bars.