Question about adjust text size.

[kjspear]

Hello,

I have a question about formating text on reports. Okay, I know that the Can shrink and Can Grow could be used. However, that is only for vertical spacing. The problem I'm having is that I'm to have Access create Seminar Attendee name badges. I have the queries set up for this to work. I would like to keep everything on one line. For example for customers full name on one line and the Firm name on the next without wraparounds. So if the attendee's name is longer than what the space allows, the text should automatically adjust in space and size in order to fit on one line.

Is there a simple way to do this?
Any assistance will be appreciated.

KJ

 

[ZmrAbdulla]

I think concatenating the fields inot one will do it.
Something like =FirstName & "" & MiddleName & "" & LastName
You have to use one textbox instead of three.

Zameer Abdulla
Visit Me (New Look & style)

 

[kjspear]

I'm not yet familar with VB code. But I was looking to see how I can get access to read up to a certain amount of string lengths. If the length exceeds 15 then change the font size from 20 to 16 and left justify the text. I currently have it set on times roman font size 20 and centered on the name badges.

Any assistance will be appreciated.

Thank you,
KJ

 

[ProgramError]

hi

open the report in design view.
select the textbox where the name is goin to be displayed.
goto the menu bar and click format/conditional formatting...
goto the first dropdown box under 'condition 1'
change it to 'expression is'
type in your expression in there to test for the length of the name
something like

if (len(namestr)>10)

someone esle may help you out with the expression.
But this is where you can alter the font size and colours programmatically.

hope this helps

Program Error
Programmers do it one finger at a time!