Floating form

Resolved · Low Priority · Version 2003

Wed 4 Mar 2009, 14:40 Delegate Darren said...

Darren has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Floating form

How do you make a form open in the center of the screen as opposed to the top left?

Thu 5 Mar 2009, 15:50 Trainer Stephen said...

RE: Floating form

Hi Darren

Thank you for your question

You need to create a macro that will run when the form opens. This macro will have two commands

Restore will first restore the form.

MoveSize will then set the position and size of the form. It has 4 arguments right, down, width and height. They specify the position and size in centimeters or inches of the form.

Hope this is useful

Regards

Stephen

Thu 12 Mar 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips