Formatting!

  • Thread starter Thread starter gp
  • Start date Start date
G

gp

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
 
Hi,
I happen to know this one:
1. I'm not sure why this happens, but I'm pretty sure the
CanShrink and CanGrow of controls only apply vertically.
which kind of makes sence, as many of the forms are
designed as table. If you shrink the controls too much
horizontally, then they grow vertically, which causes the
CMS
9090
effect you've witnesed.

one solution i can offer is to perform this expression:
[Field1] & " " & [Field2] & " " & ...
to include all the fields, when at most you're risking in
a few extra spaces (you could also get rid of those using
IIF, but that's complicated), and place it in a single
control's Source property- either directly or in the
underlying query. so you won't have so many spacings.

2. Repeat tthe quotation marks:
DefaultValue = "Thickness: +/- 0.07"" ; L & W +/-
0.008"", -0.00 """
remember you should also be careful with this if you're
using this field as criteria etc.
HTH,
Ayelet
 
Back
Top