John Colby
jwcolby at gmail.com
Thu Dec 12 13:43:50 CST 2013
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.