microsoft/access/training/courses - manually formatting forms

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft/access/training/courses - Manually Formatting Forms

microsoft/access/training/courses - Manually Formatting Forms

resolvedResolved · Low Priority · Version Standard

Manually Formatting Forms

I would like to customise my Forms in Access to visually match my paper versions, can you give me some formatting tips?

RE: Manually Formatting Forms

Answer to the question:
Formatting Forms is carried out in Design vew, if you have created your Form using the Form Wizard you may have added background formatting to it already, however if your form is blank and only has fields on it you can move these fields (known as Controls and Labels) to wherever you want. If you hover your mouse over a control or its label, you will see a small hand appear, this is the move tool and with the left mouse button you can move the control and its label as one, however in the top right of each control and label is a small square, hovering your mouse pointer over one of these, you will see a pointed finger, with the pointed finger tool you can move either the control or the label independently of each other to any location you desire. Moving the controls and their labels to match your paper version should now be quite quickly and safely accomplished.
Advanced operations on Forms and Reports is covered in the Access Advanced Course.


 

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips


Server loaded in 0.08 secs.