WEBVTT
Kind: captions
Language: en

00:00:09.469 --> 00:00:13.769
When you're creating a form, Access allows
you to make some very detailed changes using

00:00:13.769 --> 00:00:15.749
the Property Sheet.

00:00:15.749 --> 00:00:19.850
To open the Property Sheet, first make sure
that you're in Layout view, and then in the

00:00:19.850 --> 00:00:23.890
Design tab, select the Property Sheet command.

00:00:23.890 --> 00:00:27.029
There are several different tabs that you
can choose from.

00:00:27.029 --> 00:00:33.420
And in each row, you'll see the property name
on the left… and the value on the right.

00:00:33.420 --> 00:00:39.100
Sometimes, you'll need to type in the new
value that you want… but some properties

00:00:39.100 --> 00:00:44.550
have one or more buttons that you can click
to choose a value.

00:00:44.550 --> 00:00:47.799
Now you should always pay close attention
when you're making changes.

00:00:47.799 --> 00:00:52.190
Since there are so many options, it may be
difficult to remember exactly what you've

00:00:52.190 --> 00:00:55.150
changed, and what the original values were.

00:00:55.150 --> 00:01:00.180
But if you don't remember what each property
does, you can just click on it…

00:01:00.180 --> 00:01:04.259
And a brief description will appear in the
bottom-left corner of the screen.

00:01:04.259 --> 00:01:08.360
So this property controls the vertical position
of the object, relative to the top of the

00:01:08.360 --> 00:01:11.490
form.

00:01:11.490 --> 00:01:14.570
In this form, I'd like to hide the ID field.

00:01:14.570 --> 00:01:20.000
I'll select it… and then in the Property
Sheet I'll go to the Format tab.

00:01:20.000 --> 00:01:23.180
And then find the property that says "Visible."

00:01:23.180 --> 00:01:27.100
Right now it's set to Yes, but you can click
on it and then use the drop-down menu to change

00:01:27.100 --> 00:01:30.920
it to No.

00:01:30.920 --> 00:01:36.909
We can switch to Form view to test it.

00:01:36.909 --> 00:01:39.680
And this field is now invisible.

00:01:39.680 --> 00:01:43.510
And at any time, if we wanted to make it visible
again, we could go back to the Property Sheet

00:01:43.510 --> 00:01:45.940
and change it.

00:01:45.940 --> 00:01:49.770
Now I'd also like to modify the Orders form.

00:01:49.770 --> 00:01:55.670
I'll first switch to Layout view.

00:01:55.670 --> 00:02:00.020
In this form, I'd like the Pickup Date field
to default to the current date whenever we

00:02:00.020 --> 00:02:02.250
create a new order.

00:02:02.250 --> 00:02:08.270
I'll select the field… and then in the Property
Sheet I'll click the Data tab… and then

00:02:08.270 --> 00:02:11.420
find the Default Value property.

00:02:11.420 --> 00:02:15.170
In order to get the current date, we'll need
to add an expression.

00:02:15.170 --> 00:02:19.590
Click this button to open up the Expression
Builder.

00:02:19.590 --> 00:02:23.340
In the lower left, there is a box called Expression
Elements.

00:02:23.340 --> 00:02:29.330
There are several different options… and
click on the one that says Common Expressions.

00:02:29.330 --> 00:02:34.530
And then to the right, we can choose either
Current Date, or Current Date and Time.

00:02:34.530 --> 00:02:37.090
We'll just choose the first one.

00:02:37.090 --> 00:02:43.730
To the right of that, double-click Date…
and it will appear in the area above.

00:02:43.730 --> 00:02:49.360
Then when you click OK, the expression will
appear in the Property Sheet.

00:02:49.360 --> 00:02:56.209
And let's switch to Form view so we can test
it.

00:02:56.209 --> 00:03:00.739
When we create a New Order… it clears all
of the fields.

00:03:00.739 --> 00:03:04.420
But the Pickup Date field will default to
the current date.

00:03:04.420 --> 00:03:08.510
We can still change it if we want to, but
for most orders we're probably not going to

00:03:08.510 --> 00:03:13.379
need to, and that's definitely going to save
us some time in the long run.

00:03:13.379 --> 00:03:17.540
In the next video we're going to finish the
Customers form by making some adjustments

00:03:17.540 --> 00:03:19.510
to the layout and the formatting.