Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Format of recrod in report

Posted on 2000-05-01
6
Medium Priority
?
231 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 200 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

670 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