Changing label sizes

[DBL]

Hiya

I've got a database that is going to be used by multiple people. There is an option to print labels and at the moment the user has to use the label size I've set. Is there any way to make the label report dynamic so that they can specify the label size they want to use as the report opens? They'll be getting an .mde so they can't fiddle about or create reports themselves.

 

[llkhoutx]

Set the size in a field on a form, maybe from a combobox, then on the report's OnFormat event reset the label size using the value stored on the form.