[AccessD] Modify label on a form in vba and save

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Fri May 27 11:20:05 CDT 2011


Only if the users have an MDB file that they are working with, and you'd have to open the form (via code) in design mode to make the change and then save it. All very messy.

Much simpler way to do this is to save the date in a table. Then when the form opens you can look up the date in the table and then change the label caption. All this can be done in the form's Load event.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jack and Pat
Sent: Friday, May 27, 2011 12:13 PM
To: AccessD Group Discussion
Subject: [AccessD] Modify label on a form in vba and save

 

Hi Group,

I had a question from an Access 2003 user. He has a Form with an option group and some labels.

On one of the Options he wants to update the label  to include the Date the option was selected. The result to be that when the Form is opened in Future, the label for that Option will show that "last used Date" appended to the original text.

 

?? Is it possible to Update the label on a form, and save the result via vba?

 

Jack

--
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