when you're creating a form access
allows you to make some very detailed
changes using the property sheet to open
the property sheet first make sure
you're in layout view and then in the
design tab select the property sheet
command there are several different tabs
that you can choose from and in each row
you'll see the property name on the left
and the value on the right sometimes
you'll need to type in the new value
that you want but some properties have
one or more buttons that you can click
to choose a value now you should always
pay close attention when you're making
changes since there are so many options
it may be difficult to remember exactly
what you've changed and what the
original values were but if you don't
remember what each property does you can
just click on it and a brief description
will appear in the bottom left corner of
the screen so this property controls the
vertical position of the object relative
to the top of the form
in this form I'd like to hide the ID
field I'll select it and then in the
property sheet I'll go to the format tab
and then find the property that says
visible right now it's set to yes but
you can click on it and then use the
drop down menu to change it to no
we can switch to form view to test it
and this field is now invisible and at
any time if we wanted to make it visible
again we could go back to the property
sheet and change it now I'd also like to
modify the orders form I'll first switch
to layout view
in this form I'd like the pickup date
field to default to the current date
whenever we create a new order I'll
select the field and then in the
property sheet I'll click the data tab
and then find the default value property
in order to get the current date we'll
need to add an expression click this
button to open up the expression builder
in the lower left there is a box called
expression elements there are several
different options and click on the one
that says common expressions and then to
the right of this we can choose either
current date or current date and time
we'll just choose the first one to the
right of that double-click date and it
will appear in the area above then when
you click OK the expression will appear
in the property sheet we can now close
this
and let's switch to form view so we can
test it
when we create a new order it clears all
of the fields but the pickup date field
will default to the current date we can
still change it if we want to but for
most orders we're probably not going to
need to and that's definitely going to
save us some time in the long run in the
next video we're going to finish the
customers form by making some
adjustments to the layout and the
formatting like what you just saw rate
it add a comment subscribe to our chill
the freedom to learn what you want when
you want absolutely free
GCF learn free.org