Tony Septav
TSeptav at Uniserve.com
Fri Dec 13 12:38:31 CST 2013
Hey John You thick as brick. Do not do it OnChange, try KeyUp or KeyDown. Tony Septav Nanaimo, BC Canada -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: December-13-13 12:27 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] I just gotta vent 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