Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access class microsoft training - default value field

Forum home » Delegate support and help forum » Microsoft Access Training and help » access class microsoft training - Default value in a field

access class microsoft training - Default value in a field

ResolvedVersion Standard

Sin has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Default value in a field

I would like the default value in a date field to be the date that the form is being used so that the user has the choice of keeping that date rather than inputting it manually. how do I do this?

RE: Default value in a field

Hi Sinead

It sounds like you want to default the Date field on the form to the current date.

To do this:

Set the Default value for the Date Text Box on the form to

=Date()

This will always show the current date (as set by the PC's internal clock)

Regards

Carlos

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.