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

form entry

ResolvedVersion 2003

Adele has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Form entry

How do I make a field mandatory?

RE: Form entry

Hi Adele

One way to make a field mandatory is when creating the table. To do this:

1. Create the field in the table's design view
2. In the General design area for that field set Required to Yes

Then when you try and enter data through the form the table won't update until you have entered the required data.

Hope this helps

Carlos

RE: Form entry

Hi Carlos,

Thanks for your answer - one more thing - can I then set up some text to show if this field is then missed in form entry? Today there's no warning, but the record is not saved.

Many Thanks,
Adele.

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

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.87 secs.