Dynamic Font Size in queries

[Phil Murray]

I have an Access (2002) application heavily dependent on query output. I've
been looking for ways to change fontface, size, and color on-the-fly but
can't find anything. I know that there are ways to automatically apply such
choices on a NEW query, but I can't find a way to do it on old queries. I
have hundreds of queries and I want to give the user (many users) a choice
of the look and feel of the query output.

Any suggestions would be appreciated.

Paul

 

[boblarson]

Queries aren't designed for presentation; forms are. I would be surprised to
find a way to do that but, in reality, users should never really be using
tables or queries directly. They should be accessing the data via forms as
you lose control as you have no events to use to trigger anything and you
don't have as many validation options.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________