Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Format of recrod in report

Posted on 2000-05-01
6
Medium Priority
?
239 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 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

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.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

916 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