Forms and background colour

  • Thread starter Thread starter -- Paul --
  • Start date Start date
P

-- Paul --

Some help Please

I started to create a mail merge in word and got to the point where you
enter names and address etc. Rather than finish the merge though, I saved
the data I had added and closed word.

I then opened the data file of names and addresses I had just entered which
opened in Access and created a form using a wizard.

I then went into table design mode and added two extra fields - one was
called ref and contained autonumber and was the primary key. The other
field was just a memo field for notes.

I now need to go back to forms in design mode and add the Ref field and
Notes field. Can someone please explain how I do this? I assume I don't
need to redisgn the form from scratch so it incorporates the two additional
fields?

Also, I used the wizard to create the form and have ended up with an nasty
looking background to the whole form (i used the ricepaper background). I
would be happier if it was just one colour. The only way I can see of doing
this is to add a rectangle, send it to the back and then colour it. Sureley
there is a better way to do this.

Thank you
 
I now need to go back to forms in design mode and add the Ref field and
Notes field. Can someone please explain how I do this? I assume I don't
need to redisgn the form from scratch so it incorporates the two additional
fields?
Click to expand...

If the Record Source for your form is the table into which you added Ref and
Notes as fields, these new fields should be in the Field List and you can
simply drag and drop them onto the form. If the Record Source for the form
is a query, just add the new fields to the query's output and they will
appear in the Field List.
Also, I used the wizard to create the form and have ended up with an nasty
looking background to the whole form (i used the ricepaper background). I
would be happier if it was just one colour. The only way I can see of doing
this is to add a rectangle, send it to the back and then colour it. Sureley
there is a better way to do this.
Click to expand...

In design view of your form, open the Properties sheet and find the Picture
property. It should say (bitmap). Highlight this value and press the
Delete key. Click into any other property and you will see a prompt which
says: "Do you want to remove this picture from the form?". Click 'Yes'.
The Picture property now should be: (none).

You are now free to set the backcolor of your form's sections (Detail, etc.)
to any color you want or to leave them in the default color.

hth,
 
Thanks for your help. I have managed to change the colour, but am still
having problem with the additional field. I will repost my query.
 
Back
Top