I'm doing a simple database with names and addresses.
How can I make the size (length) of a field relative? so that when I
make a lay-out like: Name Surname Address the filds will change their
lengths depending on the length of the name entered.
Thanks for all help.
Thomas

In article <1124352068.867714.14120 (AT) g47g2000cwa (DOT) googlegroups.com>,
"thohei" <heinesen (AT) mail (DOT) dk> wrote:

You can't change the lengths on-screen in Browse mode. You simply have
to make them a wide as will ever be necessary.

For printouts (or in Preview mode) you can use sliding, vertically and
horizontally, to close up empty spaces within fields. Stretch the field
to the maximum width / height needed, then choose Sliding / Printing
from the Format menu. Then you can choose to slide the field sideways
or vertically to close up any empty space - it takes a little playing
to get it right and you'll only see the results in a printout or in
Preview mode.

BUT, depending on what you're trying to do, it might be easier to have
a calculation field (Name & " " & Surname & " " & Address) or use Merge
fields instead.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

You can't do that easily. But there are 3 workarounds :
- use the 'Merge' menu. So 'Hello Mr <<Name>>, I'll call you', becomes :
'Hello Mr SoandSo Hyacinth, I'll call you', if Name contains 'SoandSo
Hyacinth',
or 'Hello Mr Jones, I'll call you', if Name contains 'Jones'.
- have a 'count' field, that counts the number of characters of 'Name',
and two 'Name1' and 'Name2' fields that you'll superimpose, and Name1 =
Case(count <10, Name, "") and Name2 = Case(count >=10, Name, "").. Now
format Name1 with a font size of 12, and Name2 of 9. =>painful
- enlarge vertically the size of the rectangle given to Name in the
layout, and make it shrink (slide up) on Preview mode (and Printing).
Remi-Noel


"thohei" <heinesen (AT) mail (DOT) dk> a écrit ...