Changing form background

[BIGGY]

If a form is created in design view without one of the pre-built designs. Is there a way to change that background to one of the basic ones included in Access when using the wizard?

 

[chrisdedobb]

the pictures for the default templates can be found in:

....\Program Files\Microsoft Office\OFFICE11\BITMAPS\STYLES


To attach them to the form, open the form in design view. Then open the Form properties. Under the format tab there is a field titled picture. click in there then click the ... button to browse for the file you want to use. You can also use any other pictures you might have.

Hope this helps! Good Luck!

 

[sportsguy]

Two Ways

First is through the Form Properties, and see the red box in the attached graphic, the other is through code, which is included on the Form open property, so that i can just change whatever graphic i want per form,
as long as the graphic path is known, and i just keep the graphics in the same directory as the Database i am using.

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
Set dbLocal = CurrentDb()
pstrAppPath = CurrentProject.Path

If Dir(pstrAppPath & "\graphic.bmp") <> "" Then
Me.Picture = pstrAppPath & "\graphic.bmp"
Me.PictureTiling = True
End If


End Sub

 

[BIGGY]

Perfect, got it thanks!