Solved

Format of recrod in report

Posted on 2000-05-01
6
193 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
  • 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

786 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