One of the most visually dramatic changes that you can make to a form involves changing the image that tiles across the background of a form.
Formatting with the Resize event
Since the inception of Access, form designers have been plagued by the ability of users to change the size and shape of a form. This is because controls on a form maintain their size and anchor their position to the form's top and left borders even while a form changes its size, shape, or both. Whenever a user changes the size or shape of a form, the form's Resize event fires.
"It's typical for designers to need to dynamically alter formatting to reflect the value in a textbox or other controls. Here's an example of why it's important to understand how the Access events work. With the Current event:
You can change the formatting whenever the user moves to a new record in the record source for a form.
You can change formatting when a form initially loads data for display.
However, the Current event doesn't fire when a user changes a value on the current row, so you can't use this event to respond to user input.
To respond to user-entered data, you can use the AfterUpdate event for a control to change the formatting for the value in a control after updating. While the Current event applies to a form overall, you can create an AfterUpdate event procedure for a whole form or a specific control on a form."
Look for a demo file called "502DOBSON.ZIP" (The image file in the code resides in the articles folder of the c:\ path. You'll probably need to update the path for the image files on your computer.)