Using SetValue to change form properties

  • Thread starter Thread starter in-effect
  • Start date Start date
I

in-effect

I've got a form which, by default, is formatted only display
information. This is done by disabling Combo Boxes and other Macro
Buttons. I am writing a macro that, when run, will enable the buttons
and alter the formatting of the text boxes so the data can be edited.

Although using the SetValue function for the Enabled property works
perfectly, I've not had the same success with the BackStyle property of
the text boxes. By default they are transparent and I'm trying to set
them back to normal. However, I am told that 'Normal' is an invalid
property when is blatantly isn't.

What am I missing here?

TIA,

in-effect
 
in-effect,

Would the AllowEdits property of the form be relevant to what you are doing?

To adjust the BackStyle using a SetValue macro action, set the
Expression argument to 0 for transparent and 1 for normal.
 
___ said:
You would be better to do this in code. In the forms OnLoad even
put the following code...
Click to expand...


Anonymous guy, thanks for the detailed help but it doesn't quite appl
to my situation - sorry I should have been clearer. However, it migh
indeed come in handy in the future. ;)

Steve, you were spot-on. I was misled by the ability to specify 'yes
as a value for the Enabled property - I therefore assumed I should us
the value verbatim from the properties list in design view.

Thank you for solving a very frustrating problem.

:D

p.s. One more quick question. When specifying the item within
SetValue action, can a I use a separator to specify multiple items tha
I want to have the same value? The 'help' hasn't helped much on this
TIA
 
Back
Top