Save Form Design in Macro

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

I have a macro that changes the title of a macro and its
background colour and then saves the form. The title and
colour change however when the database is opened again
the form is in the original colour and has the original
title without the changes.
 
How do you change the background color of a macro? A macro is not a control
in a form.

If you're asking how you can save changes to the design of a form, you must
open the form in design view (which you can do via macro), make the changes
to the properties, and then save the form using the "Save Changes" option as
Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top