How to Change Field Attributes in Reports 
Author Message
 How to Change Field Attributes in Reports

I have been trying to find a way to change the attributes of fields
(controls) in reports on the fly.  For example, I have a list of data
in a report:

Table info:
[Project]      [Importance]

Report Layout:
  Project      Importance
Pay Mortgage     Low
Buy Food         Med
Buy Beer         High

Based off of the Importance column I want to be able to BOLD anything
with High Importance.  I would think this might include someway of
changeing the attributes of controls [Project] and [Importance] to Bold
when Importance=High and then change it back for any other type of
Importance.

I would greatly appreciate any comments on how to solve this.  Thank
you for your time.

Matt

Sent via Deja.com http://www.*-*-*.com/
Share what you know. Learn what you don't.



Mon, 17 Dec 2001 03:00:00 GMT  
 How to Change Field Attributes in Reports
Go into the format event of the report section in which your control resides
and add a line of code that checks your condition and sets the control's
FontBold property to True or False accordingly.
Quote:

> I have been trying to find a way to change the attributes of fields
> (controls) in reports on the fly.  For example, I have a list of data
> in a report:

> Table info:
> [Project]      [Importance]

> Report Layout:
>   Project      Importance
> Pay Mortgage     Low
> Buy Food         Med
> Buy Beer         High

> Based off of the Importance column I want to be able to BOLD anything
> with High Importance.  I would think this might include someway of
> changeing the attributes of controls [Project] and [Importance] to Bold
> when Importance=High and then change it back for any other type of
> Importance.

> I would greatly appreciate any comments on how to solve this.  Thank
> you for your time.

> Matt

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.



Mon, 17 Dec 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Changing field attributes in a report

2. Access97 Field Attributes that are not in the Attributes collection of that Field

3. Change attribute values in a report

4. Change table field attributes using vba

5. Can I Change attributes in Unbound Text field?

6. Changing font attributes in an unbound field.

7. Changing field types and attributes at runtime

8. Change field attributes

9. Report on field attributes, not content

10. Modify record field attribute in report


 
Powered by phpBB® Forum Software © phpBB Group