A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

OnChange Event



 
 
Thread Tools Display Modes
  #1  
Old March 1st, 2010, 06:17 PM posted to microsoft.public.access
PeterM
external usenet poster
 
Posts: 208
Default OnChange Event

On a form in AC2003 I have a field (emailaddress). I have coded an event for
the OnChange event. The OnChange event simply concatenates a few other
literals and the emailaddress field 0nto a form textbox (emailaddressmsg). I
want the emailaddressmsg to update after each keystroke in emailaddress
hence using the OnChange event. However, it doesn't update the
emailaddressmsg until emailaddress looses focus.

How do I capture each keystroke via the OnChange event? When I run in debug
mode, emailaddress is null in the OnChange event.
  #2  
Old March 1st, 2010, 07:55 PM posted to microsoft.public.access
Duane Hookom
external usenet poster
 
Posts: 7,177
Default OnChange Event

Show your code. If you included the code in your message, you might get the
correct answer in the first reply.

It might be an issue with using either the Value or no property of the text
box when I think you need to reference the Text property.

--
Duane Hookom
Microsoft Access MVP


"PeterM" wrote:

On a form in AC2003 I have a field (emailaddress). I have coded an event for
the OnChange event. The OnChange event simply concatenates a few other
literals and the emailaddress field 0nto a form textbox (emailaddressmsg). I
want the emailaddressmsg to update after each keystroke in emailaddress
hence using the OnChange event. However, it doesn't update the
emailaddressmsg until emailaddress looses focus.

How do I capture each keystroke via the OnChange event? When I run in debug
mode, emailaddress is null in the OnChange event.

  #3  
Old March 1st, 2010, 08:31 PM posted to microsoft.public.access
PeterM
external usenet poster
 
Posts: 208
Default OnChange Event

I found the answer. You're correct, when I used the .Text property, it
returned the results that I expected.

"Duane Hookom" wrote:

Show your code. If you included the code in your message, you might get the
correct answer in the first reply.

It might be an issue with using either the Value or no property of the text
box when I think you need to reference the Text property.

--
Duane Hookom
Microsoft Access MVP


"PeterM" wrote:

On a form in AC2003 I have a field (emailaddress). I have coded an event for
the OnChange event. The OnChange event simply concatenates a few other
literals and the emailaddress field 0nto a form textbox (emailaddressmsg). I
want the emailaddressmsg to update after each keystroke in emailaddress
hence using the OnChange event. However, it doesn't update the
emailaddressmsg until emailaddress looses focus.

How do I capture each keystroke via the OnChange event? When I run in debug
mode, emailaddress is null in the OnChange event.

  #4  
Old March 13th, 2010, 05:57 PM posted to microsoft.public.access
De Jager
external usenet poster
 
Posts: 393
Default OnChange Event


"PeterM" wrote in message
...
On a form in AC2003 I have a field (emailaddress). I have coded an event
for
the OnChange event. The OnChange event simply concatenates a few other
literals and the emailaddress field 0nto a form textbox (emailaddressmsg).
I
want the emailaddressmsg to update after each keystroke in emailaddress
hence using the OnChange event. However, it doesn't update the
emailaddressmsg until emailaddress looses focus.

How do I capture each keystroke via the OnChange event? When I run in
debug
mode, emailaddress is null in the OnChange event.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.