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 >