[AccessD] I just gotta vent

 >Not sure I follow that. As Shamil said, what are you using to 
determine the focus? Screen.ActiveControl?

The control HAS the focus.  I am TYPING IN IT.  In the ONCHANGE event I 
ask for ThixCtl.text and am told "the text property is only available if 
the control has the focus"

EXCUSE ME?

How can the OnChange be firing if the control does not have the focus.

"By design" means that we have pretty toolbars to design and haven't got 
time to fix bugs that have been around for TEN YEARS.

 > Don't get that. I use unbound controls all the time for searches.

I don't doubt that.  What you DON'T do is use the .text property to do 
it because "the control doesn't have the focus".  Even though I am 
TYPING IN IT.

BUG folks.

Understand that this works just fine IF the (bound) form had a recordset 
displaying something.  But think about it.  This is an EDIT form.  There 
should not be a new record, this is for editing existing records.  The 
user is not allowed to enter new records. There should not be "some fake 
record just to allow this to work". The form should be blank and I 
should be able to do exactly what I am doing in order to select some 
value to go get existing records.

jwc

On 12/13/2013 8:38 AM, Jim Dettman wrote:
> <<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.>>
>
> Not sure I follow that.  As Shamil said, what are you using to determine
> the focus?  Screen.ActiveControl?
>
> <<2) TxtBox.Text is not available unless the control has the focus.>>
>
>   That would be correct.   .Oldvalue is the record prior to editing, .Value
> is the current value or the control, and .text is the keystroke buffer
> before it has been committed to the control.
>
> <<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.>>
>
>   Correct.
>
> <<4) So at least one record has to be displayed in the form BEFORE the
> search can be used.>>
>
>   Don't get that.  I use unbound controls all the time for searches.
>
> Jim.
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
> Sent: Thursday, December 12, 2013 02:44 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] I just gotta vent
>
> Trying to do some search kind of stuff using a text box to allow a user
> <<snip>>
>