By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Access: Colorizing Query Results in Report

P: 1
When reporting the results of a select query which searches for particular words or phrases in a memo field, is it possible to bring attention to those words in the report using color?

Thanks!

Debbie
Feb 16 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
When reporting the results of a select query which searches for particular words or phrases in a memo field, is it possible to bring attention to those words in the report using color?

Thanks!

Debbie
Hi,

It have to be possible you need to search in Access basic more for Print method that concerns the reports!

:)
Sep 9 '06 #2

PEB
Expert 100+
P: 1,418
PEB
This is an exemple from Access basic that do colored texts...

Expand|Select|Wrap|Line Numbers
  1.     Set rpt = Me
  2.     strMessage = "DisplayMessage"
  3.     With rpt
  4.         'Set scale to pixels, and set FontName and
  5.         'FontSize properties.
  6.         .ScaleMode = 3
  7.         .FontName = "Courier"
  8.         .FontSize = 24
  9.         .ForeColor = 255
  10.  
  11.     End With
  12.     ' Horizontal width.
  13.     intHorSize = rpt.TextWidth(strMessage)
  14.     ' Vertical height.
  15.     intVerSize = rpt.TextHeight(strMessage)
  16.     ' Calculate location of text to be displayed.
  17.     rpt.CurrentX = (rpt.ScaleWidth / 2) - (intHorSize / 2)
  18.     rpt.CurrentY = (rpt.ScaleHeight / 2) - (intVerSize / 2)
  19.     ' Print text on Report object.
  20.     rpt.Print strMessage
  21.  
Sep 9 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.