[AccessD] I just gotta vent

Charlotte Foust charlotte.foust at gmail.com
Fri Dec 13 12:38:07 CST 2013


Does the GotFocus event fire when you enter the textbox?

Charlotte


On Fri, Dec 13, 2013 at 10:26 AM, John Colby <jwcolby at gmail.com> wrote:

> LOL, Charlotte...
>
> From my immediate previous response...
>
>
> 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"
>
> Understand this appears to be a "special case" that a million others are
> complaining about on Google, and have since the early 2000s.
>
> 1) Bound form
> 2) No data displayed on the form.  IOW all of the controls themselves in
> the detail sections are not displayed at all.
>
>
>
> On 12/13/2013 12:59 PM, Charlotte Foust wrote:
>
>> John, where are you seeing the exception?  Is it in a popup error message
>> or when you're stepping through the code?  The text property isn't
>> available from the IDE as I recall, because the focus is in the IDE.
>>   Anybody else have a different experience with that?  It sounds like you
>> want to make the textbox behave like the textbox portion of a combobox.  I
>> generally force the user to click a search button or something to make
>> sure
>> the textbox value is available.
>>
>> Charlotte.
>>
>>
>> On Fri, Dec 13, 2013 at 6:28 AM, John Colby <jwcolby at gmail.com> wrote:
>>
>>  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>>
>>>>
>>>>
>>>>  --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>>
> --
> 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