Default Settings in the Form Design?

[gblack]

Hey, Is there anyway to set the defaults for the form design?

I went into Options and changed everything as far as fonts and font size, but that only changes the way the queries come up…

I want to have Access make all my fields in the design of the form to automatically come up in Time New Roman font size 12…

Otherwise every time I make a new Textbox, I have to go in a change the Fonts and resize the textbox to these specs. Its nothing I can’t do, but I thought it would make things much easier, if they just came out the size I need from the get-go… Any Ideas?

 

[Autoeng]

What about using Tools-Options-Forms/Reports-Form Template. I'm not sure how it works but I'm sure Access Help will detail.

 

[gblack]

Thanks! I'll try that!

 

[dungstar]

Dynamically Changing Form Style Design

This is a very effective method that I have used again and again, in changing the form style design and making them all uniform in format.

This will go through each form (or by altering the conditional, to go to selected forms) and alter form properties.

--------

Private Sub cmdChangeForms_Click()
On Error Resume Next

Dim db As Database
Dim Doc As Document
Dim TheReport As Report
Dim TheForm As Form
Dim Cntr As Container
Dim ctl As Control
Dim prop As Property
Dim tbls As TableDefs
Dim tbl As TableDef
Dim fld As Field
Dim TheTable As TableDef

Set db = CurrentDb

'forms
Set Cntr = db.Containers!Forms
For Each Doc In Cntr.Documents
If Doc.Name <> "frmHidden" Then
DoCmd.OpenForm Doc.Name, acDesign
Set TheForm = Forms(Doc.Name)
'TheForm.Section(0).BackColor = Me.Section(0).BackColor
'TheForm.Section(1).BackColor = Me.Section(1).BackColor
'TheForm.NavigationButtons = False
'TheForm.Section(2).Height = 0
'TheForm.RecordSelectors = False
'TheForm.AutoCenter = True
TheForm.CloseButton = False
DoCmd.Close acForm, Doc.Name, acSaveYes
End If
Next Doc

MsgBox "Done changing the properties on all relevant objects."

End Sub

 

[gblack]

THANKS!