Appearance and ergos - access database

[Uncle Wulf]

I'm working on modifying an Access 2003 database that was bequeathed
to me by my predecessor. The database part of things is proceeding
apace, but the UI is absolutely horrid! The colors are garish, and the
text is to small, among other things. Leads to eyestrain in very short
order.

I could edit the various forms to improve things, but we're talking
about 60+ forms here! Is there a feature in Access that would allow
me to change things en masse? [Like a style sheet in a website?]

 

[Douglas J. Steele]

I could edit the various forms to improve things, but we're talking
about 60+ forms here! Is there a feature in Access that would allow
me to change things en masse? [Like a style sheet in a website?]

Unfortunately, there is no style sheet equivalent.

It is possible, though, to change properties programmatically by opening the
form in design view, then working with controls on the form:

Dim frmCurr As Form
Dim ctlCurr As Control

DoCmd.OpenForm "NameOfForm", acDesign
Set frmCurr = Forms("NameOfForm")
Set ctlCurr = frmCurr.Controls("NameOfControl")
ctlCurr.BackColor = vbRed
DoCmd.Close acForm, "NameOfForm, acSaveYes
Set frmCurr = Nothing

 

[Uncle Wulf]

Unfortunately, there is no style sheet equivalent.

It is possible, though, to change properties programmatically by opening the
form in design view, then working with controls on the form:

Dim frmCurr As Form
Dim ctlCurr As Control

DoCmd.OpenForm "NameOfForm", acDesign
Set frmCurr = Forms("NameOfForm")
Set ctlCurr = frmCurr.Controls("NameOfControl")
ctlCurr.BackColor = vbRed
DoCmd.Close acForm, "NameOfForm, acSaveYes
Set frmCurr = Nothing

Thank you, Sir. I'll have a go at it first thing in the AM.

One other [stupid?] question, if I may.... Where's the property that
controls the title bar text?

 

[Uncle Wulf]

One other [stupid?] question, if I may.... Where's the property that
controls the title bar text?

Never mind, found it.

I gotta quit working this late. I'm starting to look right past the
obvious things.