Database Reference
In-Depth Information
12
Make the
Form Header
section just tall enough to contain the title control.
Next, suppose we don't want users to be able to change the value in the CategoryID
text box control. Let's disable it so that its text and background are gray.
13
In the
Detail
section, click the
CategoryID
text box control, and on the
Design
tool
tab, in the
Tools
group, click the
Property Sheet
button.
KEYBOARD SHORTCUT
Press F4 to open and close the Property Sheet pane. For a list
of keyboard shortcuts, see “Keyboard shortcuts” at the end of this topic.
14
In the
Property Sheet
pane, click the
Data
tab. Click the
Enabled
property, click its
arrow, and click
No
. Then close the
Property Sheet
pane.
15
Click the
Category Name
label control, double-click
Category
, and then delete it and
the following space.
Now let's add the category description from the Categories table to this form.
16
Drag the bottom of the
Detail
section down until the section is about
2.5
inches tall.
Then drag the right border until the form design grid is about
5
inches wide.
TIP
You cannot change the width of sections independently; widening one section
widens the entire form.
17
On the
Design
tool tab, in the
Tools
group, click the
Add Existing Fields
button to
open the
Field List
pane.
You can click Show All Tables to display the fields from other tables in the database.