Dynamic Font Size in queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Murray - 24 Feb 2008 21:25 GMT

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

Reply to this Message

boblarson - 25 Feb 2008 06:49 GMT

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.

Signature

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.
__________________________________

> 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
[quoted text clipped - 6 lines]
>
> Paul

Reply to this Message