Book

Suggestions


Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

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

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Monday, August 11, 2008 – Permalink –

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

Labels: ,


<Doug Klippert@ 3:41 AM

Comments: Post a Comment