VBA code to make text box italic

[tariq1]

Hi, as a starting point I am trying to make the font of a text box 'Tenant Code' italic, but no joy with the below:

Sub taz()

Forms!("Tenants").Controls("Tenant Code").FontItalic = True
End Sub

The error message is:


Compile error: Type-declaration character does not match declared data typq

[RayMilhon]

Why are you doing it in VBA? If the control is on a form and you always want it Italic as your code suggests just use the properties on the control

[tariq1]

Hi Ray,

Thank you for your quick response, yes I know I can use just alter the propertysheet,
but for my education why does the above code not function?

Thank you

[Robeen]

Tariq - I think your syntax is not correct. Take a look at this page and see if it helps you to get it right.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[RayMilhon]

I have to agree with Robeen the syntax looks off to me
If its the current form use me.controlname.fontitalic = true

[tariq1]

Thank you for your assistance. I have now rectified the syntax