Solved

Format of recrod in report

Posted on 2000-05-01
6
219 Views
Last Modified: 2008-03-06
I'd like to now if it's possible and how to format a row of a report at runtime.  I mean, I want the row to be in italic if one of the field is not empty
0
Comment
Question by:gfaucher
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 1

Expert Comment

by:koengi
ID: 2765694
Just go to properties and there you can set the font in bold, italics.

0
 
LVL 1

Expert Comment

by:scheffera
ID: 2765727
In the on format event of the detail set the format of the field.  It would be something like this:

FieldName.FontItalic = -1


Don't forget to set it back to 0 or all of the records will be italic.  
0
 
LVL 1

Accepted Solution

by:
scheffera earned 50 total points
ID: 2765733
set the condition first:

if isnull(FieldName ) then
    FieldName.FontItalic = -1
else
    FieldName.FontItalic = 0
end if


that's a better example, put that in the Detail_Format subroutine of the report

0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:gfaucher
ID: 2765764
koengi

I know that, but I cannot do that at runtime
0
 

Author Comment

by:gfaucher
ID: 2765779
Thanks a lot!!
I've tried something similar but it haven't worked
0
 
LVL 1

Expert Comment

by:scheffera
ID: 2765805
My pleasure..... :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question