Changing Label Names with Code?

[Guest_imported]

I was wondering if I could use VBA to change the name of a label on a form. For example, I have 20 labels named Label1, Label2, Label3,... and so on. Is there a way that I can use something like:

Dim lbl As Label
For num = 0 To 20
lbl.Name = "Label" & num
lbl.Caption = DLookup(something)
Next

I can't get it to work. Thanks.

 

[oharab]

Dead easy & you are nearly there:


For num = 0 To 20
me.controls("label" & num).caption=DLookup(something)
Next num

Enjoy

Ben ----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------