Unofficial Office Stuff

  Web http://www.klippert.com
TOPICS


  Monday, April 25, 2005 – Fixed link –

ACCESS




Dynamic Formatting of Forms


GetFocus, Resize, Color Data


Here is a description about how to perform three different actions on forms to respond to data entries or changes in events.


MSDN.Microsoft.com:
Eventful Formatting for Access Forms
By Rick Dobson - SmartAccess magazine

Formatting with GotFocus and LostFocus events
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.

Formatting Data
"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.)

Also see:


Access MVPS.org:
Colors and Continuous forms

Changing the Background Color of the Current Record


See all Topics

Doug Klippert@ 6:49 AM

Comments: Post a Comment

index

Home Page

RSS Blog version

Bloglines

websites

OfficeZealot

Scobleizer

TechRepublic

WOPR

link


Add to My Yahoo! This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker