Where did the SetValue action go?

Where did the SetValue action go?

Post by aHViYm » Fri, 09 Jan 2009 10:21:00


I recently installed Office 2007 on my computer, including Access. I have a
control on a form, a combo box, that is, set the value to spaces for the Lost
Focus event. I want to use the macro builder to set the value. When I list
the available actions by clicking the down arrow in the 'Action' column in
the macro builder, I do not see the SetValue action listed. What gives? Is
there some add-in that I need to include or something I needed to do during
the installation that allows me to insert the SetValue action into a macro.
There is nothing I can find in the help system that addresses this. As a
matter of fact, it has instructions on how to use the SetValue action. What
am I missing here?

Hubba
 
 
 

Where did the SetValue action go?

Post by Jeff Conra » Fri, 09 Jan 2009 11:50:13

Hi Hubba,

See this page on my site:
http://www.yqcomputer.com/

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.yqcomputer.com/
Access 2007 Info: http://www.yqcomputer.com/

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.yqcomputer.com/
----------

 
 
 

Where did the SetValue action go?

Post by aHViYm » Sat, 10 Jan 2009 00:34:15

Hi Jeff,

Thank you so much for the answer. I haven't used Access for a couple of
years and wasn't aware of this change to the macro builder and the means to
activate the full list of actions. By the way, I'm impressed with your
website.

Hubba
 
 
 

Where did the SetValue action go?

Post by Jeff Conra » Sat, 10 Jan 2009 11:46:21


You're welcome, glad to help.


Thank you for the nice comment. Good luck with your project.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.yqcomputer.com/
Access 2007 Info: http://www.yqcomputer.com/

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at:
http://www.yqcomputer.com/
----------