Changing label captions with VBA

[Allen Browne]

If you make the changes in design view, and save the form, Access saves the
changes.
If you change them programatically and then close the form without using
design view, the changes are not saved.
If you change them programatically, switch to design view, make other
changes, switch back to form view, and then save them, the design changes
are saved.

BTW, Neal, I did a form like that several years ago. I used text boxes
instead of labels, and programatically set the date for each text box in
Form_Open. The Format property of the text boxes was just d, so they showed
just the day of the month. Under each text box was a subform: yes 35
instances of the same subform. The LinkMasterFields/LinkChildFields
properties used the date in the text box so that the right information
automatically appeared in the subforms for each date.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")

"Neal Tipton" <tipton@gvtc.com> wrote in message
news:0TfVa.829$V_4.34708@eagle.america.net...

> I have an unbound form that is a one year calendar. The days for each

month

> are made of 42 labels (6 rows of 7 plain boxes) with sequential names and

on

> the form's open event, each label is made visible or invisible, and it's
> caption is changed to the day of the month. In addition, the 12 labels

for

> the months have their captions changed to the appropriate month of the

year.

> Here's the problem: I have noticed when I first started working with this
> form that whenever I closed the form and opened it in design mode the
> changes made to each label were gone and the original captions were
> reinstated. This was always the case until I started tweaking the

form_open

> event to also read in special abbreviated notations for marked days from a
> table. Now it saves the altered version of the calendar and the caption
> changes can still be seen if you open the form in design mode. This is

not

> so much of a problem, really except that I don't know what the rule is.
> WHEN does Access make changes to labels made via VBA permanent and when

does

> it not?
>
>

[vanauden]

To programatically (VBA) modify a form or report label in Access (I'm using 2010), you need to use .Caption

Me. (means the form you are in. You can also explicitely refer to the form using the following Forms!frm_Name!labelname)

Me.Label11.Caption = "new label text"

It is that easy.