Formatting

[pgp]

Hi ,

I have a report with a lot of text boxes displaying data from table.

Problem 1:
I have this one line
Certs: COM MIL CMS9090 OV% 25 on the report where
"Certs:" and "OV%" are both labels and others text boxes.

Even though I have the Can shrink of all the text boxes to Yes - its not formatting properly. Its either got a lot of spaces or displays as follows:

Certs: COM MIL CMS OV% 25
9090

Does anyone know why this happens?

Problem 2:

On one field Tolerances in a table - I've declared this field as text type and would like to default it to

Thickness: +/- 0.07" ; L & W +/- 0.008", -0.00 "

how do I do this with the inches " sign?? since whatever text I need to default, I should be writing the text within quotes , and with these inches in the middle, it messes up the entire text.

Thanks in advance for any help

 

[WayneRyan]

pgp,

The Can Grow and Can Shrink properties refer to the vertical
axis.

If you expected the textboxes to stretch horizontally, then you
will have to do that with code.

As for the quotes:

Me.SomeControl = "Thickness: +/- 0.07"";"

Will give you Thickness: +/- 0.07"

Wayne

 

[pgp]

Hi !

Thanks Wayne for your help!!
It worked!!

About the horizontal text box formatting - do I have to adjust the width property everytime the length of the string changes or?

Thanks again