changing controls specialeffect at runtime

[questionit]

Hi

I used this code to change the special effect of the controls.
After this, the form is saved.

    Dim ctl As Control
 
    For Each ctl In Me.Controls
        If TypeOf ctl Is ComboBox Then
           ctl.SpecialEffect = 0
           ctl.BorderColor = RGB(255, 128, 140)
        End If
     Next ctl
 
     DoCmd.Save acForm, "Form1"
 

When i close the form and re-open it ,all the changes are not there.

Why does it do that when i save the form as well from code itself ?

Thanks
Qi

[nico5038]

Change

DoCmd.Save acForm, "Form1"

into

DoCmd.Close acForm, "Form1", acSaveYes

And tell me the result. Make sure that the form is open in edit mode when running the code !

Nic;o)

[missinglinq]

The DoCmd.Close acForm, "Form1", acSaveYes

part is correct, but I think the changes have to be made while the form is in Design View, not while the it's being used in the normal fashion.

Linq ;0)>

[nico5038]

Well detected hawkeye Linq. Should have used "Design View" instead of "edit mode" <LOL>

Nic;o)

[missinglinq]

I figured that was what you meant!

;0)>

BTW, did you once upon a time belong to those mercenary guys over at Experts-Exchange (knowledge for money)?