Changing Font Size Of Labels Depending On Text Length

Jul 28, 2014

I have a report that prints labels (similar to avery labels) which pulls data from a query. These labels are all unique and vary in length. Due to the length variance, I want the font size to get smaller for labels with more characters. I want the text to go down to another line when necessary.

In my report under the OnPage Event Procedure I wrote this:

Private Sub Report_Page()
If Len(Text2) > 20 Then Text2.FontSize = 8
If Len(Text2) > 10 And Len(Text2) < 21 Then Text2.FontSize = 10
If Len(Text2) < 11 Then Text2.FontSize = 14
End Sub

This works to some degree but the problem is that once there is a longer label, all of the proceeding labels are resized & the longer label that should have been resized was not.

Is there another place I should be writing this code? I looked under events for the textbox but there doesn't seem to be anything that would work since none of them would trigger when printing labels

View Replies


ADVERTISEMENT

Weird - Font On Text Labels Gets Bolder As I Move Through Records

Oct 19, 2005

Hi all,
title says it all!

I've got a form with numerous controls and labels. When i first open the form, all looks fine - all labels are Black Arial 8 Bold. But when i start scrolling through the records, the text on three of my text labels gets bolder. I haven't a clue what is causing this - the labels are just standard - two are associated with controls and one is all on its own.

I have no code written to do this, and in fact i'm not sure you could write code to do this. I've tried renaming the labels, changing the font, deleting and recreating them, but it's always the same three that get darker.

Ideas?

P.

View 1 Replies View Related

Can You Make Just One Part Of The Text In A Text Box Bold Or A Different Font Size?

Aug 20, 2004

Is there a way to make just part of the text in a text box bold, or to use different font sizes in the same text box?

Something like this:

---------------------------------
Heading in bold: description in regular (not bold)
(a smaller height line used as a line space)
Another "normal" line
a larger height line
a normal line....all in one text box!
---------------------------------

One thing I'd like to be able to do is to specify the line height of a blank line in a text box. I'm using carriage returns created with: Chr(13) & Chr(10). I could see defining the font size of a hidden character, but I'd need to know how to assign a font size to a piece of the text in a font box.

View 2 Replies View Related

Reports :: Text Within Report Labels Different Size In Preview / Print?

Jan 12, 2015

I have always noticed that when creating a report, when you make a paragraph using a label, the alignment and size of the text/paragraph is always different when you preview the report than when you design it.

This makes alignment of paragraphs tricky, especially when you are trying to insert a bold faced word into the middle of a block of text by using a separate label.

I am using Access 2000

View 4 Replies View Related

Changing Text Colour Of Labels On Activate

Nov 23, 2005

Hi, im working on my school project for A2.

When the user clicks on say; the customer ID dropdown menu, i want the label text on the right of it to get darker (make it more visible). How can i do this?

(i have attached a picture of my form)

thanks, Robin

View 2 Replies View Related

Forms :: Changing Color Of Text On Labels

Aug 14, 2015

I have three labels that I can't change the text color. I must have them locked or something. What should I check?

View 5 Replies View Related

Changing Rowsource In A Combo Box Depending On The Text In Another

Jul 10, 2007

Hi all,
I am trying to have the rowsource change on a "subcategory" combo box depending on what the "category" combo box says.

I added an event procedure to the "Category" combo box which changes the Row Source in the subcategory combo box to something else. I'm not sure that I did this right as if I close the database and reopen it, what I selected in the subcategory combobox is gone and it is blank. Any ideas? Here is my simple, likely incorrect event procedure:

Private Sub Category_Change()

If Category.Text = "Rare Books" Then
SubCat.RowSource = "scRareBooks"

End If

If Category.Text = "Legal Documents" Then
SubCat.RowSource = "scLegalDocuments"

End If


End Sub

Thanks!

View 5 Replies View Related

Forms :: Changing Border Of Text Box Depending On Value Of Field

Jan 9, 2014

I have a box with age in called [agecalc]. I want to change the border of the box to red to indicate they are a Juvenile if under the age of 17.I already have some code to write the text, I just need to change the border of this text box called agebox

=IIf([agecalc]<=17,"Juvenile!!")

View 1 Replies View Related

Change Font Size Of Sql Edit Window?

Nov 15, 2006

I'm running MS Access 2003. My SQL editing window has a really small font size. How do I change this window's default font size? Is it in tools or options?

Help!!!!!!! I'm going blind!!!!!!:confused:

Thank you for taking the time to read this and for being willing to help out!!

View 3 Replies View Related

Forms :: Vary Sub Form Labels Depending On Other Value

Jan 21, 2015

I have a form containing a sub form.

On the sub form I am selecting products that I am selling to a customer whose details appear on the main form.

The products on the sub form are selected from a combo box. This section is in datasheet format.

Depending on the product sold some of the labels on the sub form are not relevant. And when this is the case I was thinking maybe the label is rendered invisible.

Maybe this is not the best way to handle this - or is it. It certainly is expedient.

Perhaps as well when the label is rendered invisible entry of a value into the corresponding text box becomes impossible.

Is there a better way to handle this?

How I can render the label invisible and disallow data entry depending on the value of the combo box.

View 6 Replies View Related

Reports :: Inserting Font Size In A Report Through Programming

Jul 9, 2014

I have a form which gets information from the user and upon pressing a button I produce address labels for the user. The form calls a report which does the job. This works. Now the user would like to have parameters like fonttype, fontsize and fontcolour together with margins, row and column space so that the output can be better tailored to his needs. I have inserted combo boxes on the form to get these parameters from the user, but how am I going to insert these parameters in the report layout through programming. What should be the approach?

View 5 Replies View Related

Changing Font Color According To Selection

Jun 14, 2006

(Simplified example)

On a form I have a combo box - let's call it cmboSickness. it has two options "flu" and "malaria". On the same form I have two command buttons - one ehich opens a malaria form and one which opens a flu form. If I select flu then I want the words on the flu command button to change to red. How do I do this and where do I put the code?

I have tried -
If me.cmbosickness=flu then
cmdflu.color=255

but this doesn't work...

View 3 Replies View Related

General :: Adjust Cell Size According To Length Of Data In Datasheet

Jul 9, 2013

I have subform (Datasheet) is there some code e.g. after update, which can adjust size cell to lenght of data?

View 11 Replies View Related

Changing Font In Access Report Header

Feb 1, 2013

I have a Header with basically four rows of Text, all in Calibri. The top row is White text, 14pt, on a Dark Grey Rectangle. The other rows are Supposed to be Calibri, 12pt, Black text on White Rectangles. The issue is that when I am in Design View, it displays properly, But when I go to Layout View, the Black Text changes from Calibri to Garamond. If I look at Design View again, it Displays as Calibri, but even if I go to Layout View, Change the Font, and go to Design View again, the next time I try to Print, it changes to Garamond again. Everything else stays he same, whether the text is 12-14pt, the Color, Bold, Underline, Italic Settings. Only the Font Changes.

View 1 Replies View Related

Changing Font Color Of Just Part Of A Label

Sep 11, 2015

Is it possible to use two color fonts on one label? I want to bring attention to the user that by clicking a certain button they can perform a search by "Name" and by clicking on the other button, they can perform a search by "Appointment".

I have a switchboard type form with some buttons. The two buttons in question are labeled, "Search for Appts by Name" and "Search for Appts by Appointment". I want to keep the "Search for" section of the button in black font, but change the "by Appointment" and "by Name" to red font.

View 3 Replies View Related

Changing Allow Zero Length Default

Aug 18, 2005

Hi

Is it possible to change the default table setting in Access 2000 for the 'Allow Zero Length' property from No to Yes? Or does anyone know any code that can be run to change any existing fields with Allow Zero Length = No to = Yes?

Any assistance would be much appreciated.

Thanks.

View 2 Replies View Related

Changing Zero Length To Null

Nov 7, 2005

in my db, all fields that aren't required default to a zero-length string.

In some reports (like mailing labels) I want the rows that contain no information (like the second Address line) to "shrink". I set all my properties to "can shrink" etc., but of course it's not working, because the value of the "empty" fields is "" instead of Null.

Is there a way I can write an IIF statement that will set the value of the field to Null if it contains a zero-length string?

View 4 Replies View Related

General :: Access Keeps Changing Font In Form Control

May 18, 2015

When I change a font for a control, save it and then reopen it the font changes back to another font.

It's always the same font.

I'm trying to save it to Calibri but it reverts back to Constantia for some reason.

I've deleted the bound control and added it back but it did no good.

The only way I can change the font is to set it in the On Load of the form.

View 1 Replies View Related

General :: Changing Font Colour Of One Record In Access Database

Jan 12, 2015

I would like to get a third party to edit a database and record those edits by changing the colour of the font. I know this can be done in layout mode, but it changes the font in all records, I only wish to change the font colour in one record, how I can do this, without changing all the records in the database.

View 3 Replies View Related

Sub Form Increase In Size Depending On Data

Sep 29, 2006

I have a main form with a few imbedded sub forms.
Sometimes these is a great deal of data in one of the sub forms & non in the others.
Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks for little data)
The way I have it now is that each sub form is always the same size and a scroll bar appears when these is extra data. This is OK but I need to see all data in sub forms at once if possible.
Can anyone help with ideas please?

View 2 Replies View Related

Changing Field Length In Large Database.

Feb 6, 2006

I am trying to change a field lenght of a large database (access 97) It is at 50 right now and want to change it to 25. When I try to change it and save the table I get a error when the bar is about 3/4 the way accross the bottom.

Microsoft can't change the data type - there isn't enough disk space or memory.

then

not enough space on temporary disk

This is error 3183. In the help it says that the TEMP DOS enviroment variable location doesn't have enough space. (summerising). Now I have a 100+gb drive that isn't close to being full. I also changed the MaxLocksPerFile registry dword to 8,000,000 as my table has around over 3 million records. I have tried this on a xp and 2000 machine same results. Next I am going to try it on a 98 machine. I could do it by breaking up the table into 2 differnt ones and do each one individually but there is an autonumber field used as a reference number (I know I know). So that would screw up the numbering scheem (Yes I know there are ways arund that also). this database is about 400MB

Couple of questions
1. Is there a way around this? I have not found a solution on line yet.
2. Will lowering the field length make the database smaller (the data that is in there now is less than 25 charecters and the field is set to 50.) I have gotten mixed info on this. there are a few fields I would like to reduce.

Thanks
sam

View 2 Replies View Related

!!!changing Font Colour - Simple Question, Quick Response Required If Possible!!!

Feb 14, 2006

i have a text box which displays the current stock level of an item, when the current stock level reaches 1 i need the font to change colour from black to red.
for example, if the stock is 2 - font is black
if one item is sold the stock will become 1 - font changes to red

how do i go about this? any help is VERY VERY welcomed and muchly appreciated. thanx alot.

View 2 Replies View Related

Reports :: Variable Report Depending On Data Size

Oct 3, 2013

I have now a report that span around 2 pages. It has subreports in the report that depening how many rows there are they can grow or shrink.I have the problem that the second page the top margin is to close to the top of the pager. The paper has a logo on the right top side. I can make the first page look nice under the logo, but the second page prints to close to the edge that prints over the logo. I did add a page break, but when the page 1 has more data, it flushes this to the next page. The page 2 is now page 3. How can I avoid that, or make it so that the margin of the second page/next page is on the correct lenght of the top. I tried it with the page setup, but it does not work.

View 3 Replies View Related

Labels Changing Or Visible Swapt

Jan 13, 2005

I have a ComboBox linked to a table which allows 1,2,3,4,0 to be selected!

I want to place a Lable on the same form that reads the data in the ComboBox and displays a lable

Example: 0 = “N/A”

1 = Emergency Response

2 = Health Care

Etc.



As I scroll through all my records, the ComboBox has the value 0 to 4!



Is this possible!

I have being at it for days now! And don’t receive error debug msg! but then again , nothing happens



Any clues or ideas on how to do this !

View 7 Replies View Related

Forms :: Changing Format Of Field Based On String Length

Jun 11, 2014

I have a continuous form that displays data from a table. What I am trying to accomplish is to change the format of the field if the string length is equal to 11, to "@@@-@@@-@@@@-@". Otherwise if it is greater or less than 11 then no format.

I have tried it using code:

If Len(Me.FormFieldName)=11 Then
Me.FormFieldName.Format = "@@@-@@@-@@@@-@"
End If

Is it even possible and if so is my syntax correct or am I way off base?

View 8 Replies View Related

Reports And Changing Labels On Form Dynamically

Nov 24, 2004

I have created a report to display a bill of materials (boms). The report works as I have designed. I have also figured out how to filter the report using the docmd.openreport vbasic call with filters. This works fine. I use a form to select the filtering I need in the form of 2 Listboxes populated from tables. The form opens, the report generates and displays in preview mode. What I cannot do is the change the title text (Text Label on the report Header). I would like to use the selected items in the listboxes as sources of text for these controls on the report so I can use the report over and over for different boms. ANy help would be greatly appreciated! Vbasic I hope!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved