Hi Drew,
Many thanks - it's your PS that held the vital secret!
Can I request the OOo team to consider rewriting the Help files to
include this information? It would have taken a long time (if ever) to
discover it for myself.
One small cosmetic thing: the new field shows up as white, whilst the
original ones (created via the wizard) show up grey. How do I get the
same colour for them all? - none of the format options seem to give me
the opportunity to change the colour of the individual fields, only that
of the background of the form itself.
Brian B
Drew Jensen wrote:
Brian Blandford wrote:
After I successfully created an address book in base with table,
form, and queries all functioning correctly, I realised there was an
additional field I wanted to add. I opened the table and added an
extra column for the new field. However, I can find no way to
incorporate the new field into the form. I open the form in design
view, I draw a text box, then click on the control button, then look
in the "label field" list on the Properties dialogue that pops up,
but the new field is not included in the list.
How do I get the new field onto the form?
The "Help" files don't help for editing existing databases as far as
I can see.
Hi Brian,
Assuming that your form is based on the table, and not a query, then.
Open the form for editing.
Be sure the Form Design toolbar is open and on it click the "Add
Field" tool button ( sixth from the left ). This opens a tool window
with all fields, including your new one, displayed.
Drag and drop the new field name from the tool window to the form,
both a label and control box will be added to form, grouped.
ps - if you have done this and the tool window was empty - that is
because it changes field lists as you select different controls from
different record sets ( ala a Form/Sub-Forum layout ) in this case you
just need to click on one of the existing controls on the form and it
will fill with the field anems.
If your form is based on a query, other then SELECT * FROM TABLE then
you must open the query in edit mode, add the new field to the result
set and save edit.
Then follow the instructions above.
I HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
