Forms

The UK's most regular instructor-led training courses.
Training information: ms-access-course · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2007

Forms

Samantha has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Samantha [8 posts] (2008 Jun 24 Tue, 16:12) Reply

how do you distribute fields evenly on a form?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: forms

by - trainer Stephen gold contributer [369 posts] (2008 Jun 25 Wed, 11:32) Reply

Hi Samantha

Thank you for your question

Select the text boxes that you want to format.

Click onto the "Arrange" tab, to bring up the arrange ribbon.

Then click on either "Equal Vertical" or "Equal horizontal"

There are also controls there for increasing or decreasing the separation

Regards

Stephen

· Material covered on a Microsoft Access Course
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Microsoft Access as a Business's Database Management System
· The Benefits of Certified Microsoft Training in Access
· MS Access and Database Normalisation

Please browse our web site to find out more about
ms-access-course and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report