[AccessD] I just gotta vent

Salakhetdinov Shamil mcp2004 at mail.ru
Thu Dec 12 14:14:51 CST 2013


 Hi John --

<<<
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.
>>>
These are "features by design" AFAIKR.

<<<
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.
>>>
How do you check that a text box has focus?

<<<
4) So at least one record has to be displayed in the form BEFORE the 
search can be used.
>>>
How do you implement search functionality?

Thank you.

-- Shamil

Thursday, December 12, 2013 2:43 PM -05:00 from John Colby <jwcolby at gmail.com>:
>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.
>
>
>-- 
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website:  http://www.databaseadvisors.com


-- 
Салахетдинов Шамиль


More information about the AccessD mailing list