WEBVTT
Kind: captions
Language: en

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

00:00:15.770 --> 00:00:17.650
the Property Sheet.

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

00:00:21.760 --> 00:00:26.000
Design tab, select the Property Sheet command.

00:00:26.000 --> 00:00:29.140
There are several different tabs that you
can choose from.

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

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

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

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

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

00:00:54.370 --> 00:00:57.320
changed, and what the original values were.

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

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

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

00:01:10.380 --> 00:01:13.670
form.

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

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

00:01:22.200 --> 00:01:25.369
And then find the property that says "Visible."

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

00:01:29.280 --> 00:01:32.299
it to No.

00:01:32.299 --> 00:01:38.610
We can switch to Form view to test it.

00:01:38.610 --> 00:01:41.380
And this field is now invisible.

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

00:01:45.200 --> 00:01:47.640
and change it.

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

00:01:51.470 --> 00:01:59.000
I'll first switch to Layout view.

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

00:02:03.369 --> 00:02:06.020
create a new order.

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

00:02:12.070 --> 00:02:14.980
find the Default Value property.

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

00:02:18.660 --> 00:02:23.070
Click this button to open up the Expression
Builder.

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

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

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

00:02:37.800 --> 00:02:40.360
We'll just choose the first one.

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

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

00:02:52.280 --> 00:02:55.510
We can now close this.

00:02:55.510 --> 00:03:01.760
And let's switch to Form view so we can test
it.

00:03:01.760 --> 00:03:06.200
When we create a New Order… it clears all
of the fields.

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

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

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

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

00:03:23.110 --> 00:03:25.090
to the layout and the formatting.