access vba - How to perform font changes to a report using an option box -

access vba - How to perform font changes to a report using an option box -

i having issues trying utilize alternative box alter font on series of controls. basically, have study (named q_tblproject52week) embedded in form. have embedded alternative box within form (called "cornice33) aims alter font on 2 controls (testo107 , testo108) embedded in report.

at moment trying next no success:

if cornice33 = 1 testo107.fontname = "calibri" testo108.fontname = "times" elseif cornice33 = 2 testo107.fontname = "times" testo108.fontname = "calibri" end if

i getting missing object message (it not recognising controls testo107 , testo108). of import note, study embedded in folder control.

you need tell access refer command on study kid of form.

if cornice33 = 1 me.q_tblproject52week.testo107.fontname = "calibri" me.q_tblproject52week.testo108.fontname = "times" elseif cornice33 = 2 me.q_tblproject52week.testo107.fontname = "times" me.q_tblproject52week.testo108.fontname = "calibri" end if

hope helps

access-vba ms-access-2010