Goodwill Community Foundation creating
opportunities for a better life
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