Dates outside the range April 13, 1810 and September 16, 1989 exceed the size of an Integer field.To accommodate all possible dates, set the Field Size property of your Number field to Long Integer or greater.

The section Restrictions on data type conversions lists the ways in which you can and cannot convert data types.

The table in this section also explains when converting a data type can change or eliminate some or all the data in a field, and what data might be eliminated.

To view this example in the macro designer, use the following steps: If Updated("Status") Then Run Data Macro Macro Name Comments.

Add Comment Parameters prm Related ID = [ID] prm Comment ="--Status Changes to "&[Status] prm User ID =[Changed By User ID] End If If Updated("Resolution") Then Run Data Macro Macro Name Comments.

Use the After Update event to perform any actions that you want to occur when a record is changed.

Common uses for the After Insert include enforcing business rules, updating an aggregate total, and sending notifications.

If the original value is in the form of a valid Internet Protocol (IP) address (four number triplets separated by a period: nnn.nnn) and the numbers happen to coincide with a Web address, the conversion results in a valid link.

Otherwise, Access appends to the beginning of each value, and the resulting links are not valid.

You use update queries in Access databases to add, change, or delete the information in an existing record.