Forms

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

Resolved · Low Priority · Version 2003

1 post

ReplyFri 20 Nov 2009, 16:26Delegate Rachel said...

Rachel has attended:
Access Advanced course

Forms

How can I put in a calculated field in my form? For example a field that will automatically calculate the VAT for me?

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

642 posts

ReplyMon 23 Nov 2009, 21:39Trainer Simon said...

RE: Forms

Hi Rachel,

Thank you for your question and sorry for the delay in responding.

Create the form, save it and in Design View open the Control Toolbox. Click on the Text Box tool once and draw a text box on your form.

View the Properties window and choose the Data tab and then click on the three dots at the end of Control Source to open the Expression Builder. Then add each fields you want with the appropriate operator.

I hope this answers your question.

Regards

Simon

Mon 30 Nov 2009: Automatically marked as resolved.

· Making The Transition To Access - Why You Might Need It
· User-Level Security In Access
· Why Do I Need To Use Access?
· So You Still Haven't Learned How To Use Access Yet?
· Reasons to Consider Microsoft Access Training

Please browse our web site to find out more about
microsoft access advanced training and other Microsoft training courses.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###�s.

You could widen the column to make the date and time show, but sometimes this is not convenient: the column may already be exactly the width you want to accommodate all entries in cells further below. Maybe you don�t want to push any other columns any further to the right, because you won�t be able to see the column contents on one screen, or because it forces you to change the print settings.

The solution is to use the TEXT function to convert the value returned by NOW to text: text (as opposed to a value) stretches into the next column rather than returning ###�s. The TEXT function has two arguments: 1. the value to convert to text; 2. what format to show it in. Use custom number codes in double quote marks to specify the format. For example =TEXT(NOW(),�ddd dd/mm/yy hh:mm�) will return date and time using the format FRI 09/04/04 11:24.

View all Access hints and tips