Hi,
I am wondering if on the form properties I can have code and a macro at the same time on the oncurrent property?
I have some code for the current sheet i need to keep as is, but i also want a macro to run, There may be a better way of doing it through code but I am a newb when it comes to coding and i only know how to do it in a macro.
I have a macro that sets the back colour of the form if a property is ticked / true. The macro looks like this below. If anyone can tell me what the code would be for it instead or whether there is a way to have the macro and code running for the same property that would be great!
If [Top 20 Site]=True
Set Property
Control name Detail
Property BackColor
Value #FFD700
Else
If [Top 20 Site]=False
Set Property
Control name Detail
Property BackColor
Value #FFFFFF
End If
If someone can give me the code to do the same thing that would be great..
Also
Another question I have is... When the form is filtered the sizeable window option doesnt work. On the form i have the following properties set...
Auto Centre YES
Auto Resize YES
Fit to Screen YES
Border Style Sizeable
When on a blank new form it seems i can stretch the window and on windows 7 drag it to the top of the screen and it sizes fullscreen for me, if the form is however on a certain record or filtered the window stays static and wont stretch and you cannot freely resize or stretch it. However the properties always look the same when in design mode.
Any help for a newb would be much appreciated!!!
Many thanks
Steve
I am wondering if on the form properties I can have code and a macro at the same time on the oncurrent property?
I have some code for the current sheet i need to keep as is, but i also want a macro to run, There may be a better way of doing it through code but I am a newb when it comes to coding and i only know how to do it in a macro.
I have a macro that sets the back colour of the form if a property is ticked / true. The macro looks like this below. If anyone can tell me what the code would be for it instead or whether there is a way to have the macro and code running for the same property that would be great!
If [Top 20 Site]=True
Set Property
Control name Detail
Property BackColor
Value #FFD700
Else
If [Top 20 Site]=False
Set Property
Control name Detail
Property BackColor
Value #FFFFFF
End If
If someone can give me the code to do the same thing that would be great..
Also
Another question I have is... When the form is filtered the sizeable window option doesnt work. On the form i have the following properties set...
Auto Centre YES
Auto Resize YES
Fit to Screen YES
Border Style Sizeable
When on a blank new form it seems i can stretch the window and on windows 7 drag it to the top of the screen and it sizes fullscreen for me, if the form is however on a certain record or filtered the window stays static and wont stretch and you cannot freely resize or stretch it. However the properties always look the same when in design mode.
Any help for a newb would be much appreciated!!!
Many thanks
Steve