473,325 Members | 2,712 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Change font on report

Correct me if I'm wrong, but is it impossible to change the font in a report
field when in print preview (MDE database) or can it only be done in design
view in the MDB database.
Part of my database is used to print name tags for functions, and it would
be nice for the operator to have a choice of different fonts, colours and
backgrounds.
I have a copy of Terry Kreft and Stephen Lebans font selector mdb

Thanks

Phil
Jun 27 '08 #1
3 5584
Phil Stanton wrote:
Correct me if I'm wrong, but is it impossible to change the font in a
report field when in print preview (MDE database) or can it only be
done in design view in the MDB database.
Part of my database is used to print name tags for functions, and it
would be nice for the operator to have a choice of different fonts,
colours and backgrounds.
I have a copy of Terry Kreft and Stephen Lebans font selector mdb

Thanks

Phil
You can change the font (temporarily) using code in the various events of
the report itself. That means that you could give the user a means to
choose the font before they preview, but once opened in preview they would
have to close it, change the font choice, and then preview it again. You
cannot apply the change live on the preview window.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jun 27 '08 #2
On Sun, 13 Apr 2008 12:06:07 -0400, Rick Brandt <ri*********@hotmail.com
wrote:
You can change the font (temporarily) using code in the various eventsof
the report itself. That means that you could give the user a means to
choose the font before they preview, but once opened in preview they
would
have to close it, change the font choice, and then preview it again. You
cannot apply the change live on the preview window.
With Northwinds 2007 this allows me to change the font for the controls in
Customer Address Book report on the fly and to print in whatever font I
have chosen.
Of course, if I were going to use this I'd create something kinder that an
input box as a font chooser.
Seems to work OK after converted to ACCDE as well.

Private Sub Report_DblClick(Cancel As Integer)
Dim ctrl As control
Dim font$
font = GetFontName
On Error Resume Next
For Each ctrl In Me.Controls
ctrl.FontName = font
Next ctrl
End Sub

Public Function GetFontName$()
GetFontName = InputBox("Font Name")
End Function

Perhaps, this isn't what is being discussed, of course. I'm not sure.

--
lyle fairfield
Jun 27 '08 #3
Thanks guys

Found the easiest way was to create a table with the font charactaristics
such as name, size, colour bold etc by loading the information from the
standard font and colour picker dialogue boxes, then format the report
fields on the OnOpen Event of the report

Thanks agin for your help

Phil
"lyle fairfield" <ly******@yah00.seeaywrote in message
news:op***************@vostro-desktop.budu3.on.cogeco.ca...
On Sun, 13 Apr 2008 12:06:07 -0400, Rick Brandt <ri*********@hotmail.com>
wrote:
You can change the font (temporarily) using code in the various events of
the report itself. That means that you could give the user a means to
choose the font before they preview, but once opened in preview they
would
have to close it, change the font choice, and then preview it again. You
cannot apply the change live on the preview window.
With Northwinds 2007 this allows me to change the font for the controls in
Customer Address Book report on the fly and to print in whatever font I
have chosen.
Of course, if I were going to use this I'd create something kinder that an
input box as a font chooser.
Seems to work OK after converted to ACCDE as well.

Private Sub Report_DblClick(Cancel As Integer)
Dim ctrl As control
Dim font$
font = GetFontName
On Error Resume Next
For Each ctrl In Me.Controls
ctrl.FontName = font
Next ctrl
End Sub

Public Function GetFontName$()
GetFontName = InputBox("Font Name")
End Function

Perhaps, this isn't what is being discussed, of course. I'm not sure.

--
lyle fairfield
Jun 27 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: dixie | last post by:
I want to be able to set the font size and font type for text in a text box on a report using VBA. I wan't to be able to control it from a setting in a table. The problem is that I don't know the...
5
by: Steve | last post by:
I need a way to programatically change the width of a textbox to display all the data knowing the font, font size and number of characters. Does any oone know of a reference somewhere ot a way to...
1
by: Aaron Bronow | last post by:
I have an asp.net application which loads a Crystal Reports ReportDocument, passes in parameters for selecting data from the report's database connection, renders the report for previewing on the...
3
by: Chubbly Geezer | last post by:
I'm using a particular font (for credit card symbols) within a crystal report which looks fine when I preview, however when I run the report with real data, the font is now shown correctly. It...
1
by: ken | last post by:
Hi, How do you change the font for the data labels on your bar graph report/chart? I have 24 series, and when I change the font of the data label for one series that does not change them all......
4
by: Ross Presser | last post by:
I'm feeling very stupid about this ... pdf2html (http://pdf2html.sourceforge.net) is an app that reads a PDF and can generate HTML or XML; in my case I'm using the XML. The PDF I'm working with...
3
by: iszact | last post by:
Greetings all.. I hope you guys can help me with this. I've been doing a database for my microbiology labs, but having difficulties to change a species name into italic font. Here's what I want...
1
by: krikaran adel | last post by:
Hi, First of all I found your tips very usfull, of course these tips becuas of all years working in access. really greet site. my Quation: is this away to change fonts in reports so the...
0
by: Majid Bhutta | last post by:
Hi Dears! I am using crystal report 10 with C# 2005. I have an issue that i want to change the font of Group Header Text that is visible when we click on Toggle Group Tree button and a tree pane is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.