Goodwill Community Foundation creating
opportunities for a better life when
you're creating a forum 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
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