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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access class microsoft training - Default value in a field

Resolved · Low Priority · Version Standard

Reply Fri 27 Jul 2007, 09:57Delegate Sin said...

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?

For upcoming training course dates see: Pricing & availability

Reply Wed 1 Aug 2007, 11:35Trainer Carlos said...

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 articles

· When Is Microsoft Access Not The Best Choice For Your Business?
· How much time could you save with Access?
· What Is The Database Documenter And How Is It Used?
· Convert a Paper Trail to a DBMS
· Insert A Real-Time Clock In An Access Form

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy