Customising Access Forms: Layout, Controls and Conditional Formatting

This covers making an Access form faster and clearer to work in — layout, control properties and conditional formatting. If you are still building the form itself, start with our guide to creating forms in Microsoft Access, which covers the controls and the validation rules that stop bad data.

One principle throughout: a business form is a tool people use hundreds of times a day, not a page to be decorated. Every decision below is about speed and clarity, not appearance.

Layout: get this right first

Access gives you layouts — stacked (labels left, fields right) and tabular (a grid, good inside subforms). Controls inside a layout stay aligned when you move or resize them, which saves an enormous amount of fiddling.

Practical rules that matter more than they sound:

• Group by task, not by table column order. Fields used together should sit together, in the order the person works through them.
• Make field width signal expected length. A postcode box the width of an address invites wrong entries.
• Use tab controls for genuinely separate sections — main details, notes, history. Not to hide a form that is simply too long.
• Anchor controls so the form behaves when the window resizes.

Control properties worth knowing

Open the property sheet (F4) with a control selected. The ones that earn their keep:

• Control Source — the field it is bound to, or an expression like =[Quantity]*[Price] for a calculated display.
• Format and Decimal Places — show currency as currency and dates consistently, without changing what is stored.
• Enabled and Locked — Locked shows a value but prevents editing, which is what you usually want for a calculated or reference field. Disabled greys it out and skips it in the tab order.
• Tab Stop and Tab Index — take fields nobody types into out of the tab order entirely.
• Control Tip Text — a hover explanation. Cheaper than training and it never goes missing.
• Default Value — =Date() on a date field removes a keystroke from every record.

Conditional formatting

This is the one formatting feature with a real return, because it makes problems visible without anyone looking for them. Select a control, then Format → Conditional Formatting.

Uses that earn their place:

• Overdue dates in red — [DueDate] < Date() And [Status] <> "Complete"
• Negative stock or margins highlighted
• Rows above a value flagged for review
• Data bars in a subform column for quick visual comparison

Keep it to two or three rules. Once everything is coloured, nothing stands out — which is the same reason a dashboard with forty charts tells you nothing.

Formatting that helps, and formatting that does not

Helps: consistent fonts and sizes across every form, generous spacing around fields people use constantly, alignment so the eye can run down a column, clear labels in plain words.

Does not help: multiple typefaces, background images, colour used decoratively rather than to mean something, and cramming more on screen to avoid scrolling. Staff notice speed. They do not notice a gradient.

A useful test: sit with whoever uses the form and watch them enter ten real records. Every hesitation is a design problem, and it will be something mundane — a field in the wrong order, a box too small, a label using a word nobody in the business uses.

The limit of form design

Careful forms will make an Access database genuinely pleasant for a small team in one office. They cannot do anything about the format's own ceilings: 2GB per file, roughly ten concurrent users, and no browser or mobile access at all since Access Web Apps were discontinued in 2018.

If the complaint is that people cannot use it from elsewhere, or that it slows to a crawl when several are in at once, no amount of formatting will touch that. That is when rebuilding as a web application is the answer — and the layout thinking here is not wasted, because deciding what belongs on a screen and in what order is the hard part, and it carries straight across.

Our Microsoft Access services page covers both, and a free system review will tell you which you need.