We help IT Professionals succeed at work.

How to change to style of an existing form in Access 2003

Ange1ia
Ange1ia used Ask the Experts™
on
I have a form that I need to change the look of.  I've tried clicking on Format / datasheet (in the data sheet view) but datasheet is grayed out.  Can't select it.  

I've tried changing the background color by selecting the Paint Can from the Tool Bar, doesn't work.

How do I change the style of this existing form?

Angie
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
It's all here:

http://msdn2.microsoft.com/en-us/library/aa217449.aspx   'Kaplan Smart Access article

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
For example:


Private Sub Form_Load()
    With Me
        .DatasheetForeColor = RGB(0, 0, 0)
        .DatasheetBackColor = 13432063
    End With
End Sub

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
There is not a lot you can do with datasheets unfortunately.  What you can do is in the link I provided.

mx

Author

Commented:
I just need to change the way it looks.  It needs to be different from a similar db and they need to tell at a glance which one they are in.  If I could change the color that would work for now.  It seems to me... that at one time while I was in design view I chose something off of the Tool Bar that let you change the style, you know like when you first created the form with the wizard?

(by the way, I don't write code, don't even know where to go to write code unless it would be in properties and event)

Angie
instead of using a datasheet view use a continuous form. you will be able to change everything.
» ... but datasheet is grayed out.

I was not able to reproduce that, even with User Level Security. The most frequent way to protect formatting against tampering is to remove the “modify design” flag: users can make any change they want but they will not be saved. This doesn't disable the menu entry. Perhaps the application contains code to that effect, but that seems a long shot.

How well do you know this database? Did you create it?

(°v°)

Author

Commented:
Harfang,
I did create this db but at some point MS did work on an issue for me.  I just want to change the style of the form.  I want it to look a little different than it does now, like the Rice Paper or Explorer styles they give you when you first use the wizard to set up a form. Surely there is a way to do that?  I remember doing it at some point in the last 9 yrs I just can't remember how.  It seems like I was in the Design View when I did it and used something from the Tool Bar.  I don't remember that's why I'm asking.

Angie
i believe you are talking about the different color schemes. what you could do is create a new form pick out the one you like and create it. then go into the form in design view and click on different things and figure out the color used in the properties format tab. then change your form to match the properties of the new form.
the wizard that helps you i believe is only available in the wizard when you create a new form.

Author

Commented:
Ok Congraman,
But wouldn't that mean I'd have to pretty much create the entire form all over again?

Angie
In Access 2003, with the form in design view, choose (Format | AutoFormat), or click the button having the same name. There is one style called “Ricepaper”. As far as I know, these styles do not change the datasheet view, though.

(°v°)
you cuold but i just ment create a new form change your form to match the new one. then delete that one. just need to change some of the colors i dont see a need to create a whole new form.
harfang is it in the form's properties menu format tab?
No, it's in the main menu (and on the toolbar) while a form is in design view. It's essentially a “wizard”, and it will indeed modify format properties of sections and controls.

(°v°)
Here is one for ya. by the way i am using 2007

click on the "Microsoft" button in the verry top left corner. at the bottom of the menu click on the "Access Options" button next to the "exit Access" button.

it will bring up a menu
click on the third option down
Popular
Current Database
-- "datasheet"

brings up menu "customize the way datasheets look in Access"

you could try playing around with that
check out the picture below
customDatasheet.bmp

Author

Commented:
Harfang, that is exactly what I needed.  
It changed things just enough that it still looks enough like the old db for the users to be comfortable but different enough they will know which db they are in.
 We have 2 types of pts.  I am trying to seperate the 2 types because one doesn't require as much detail info as the other.  It's slowing down our merge documents and db in general.  If they they evolve into the type that will require more info, h/p and so on I think I can export that into the other db.  As long as the fields are matchign fields. That's the plan anyway.

Angie

Author

Commented:
I'm posting another question about setting up relationships if you want to look for that one.   Thanks for the AutoFormat answer, perfect!
Angie

Author

Commented:
Exactly what I was looking for.