Shrink the length of a field

[Paul Martin]

A few days ago I asked the question below about shrinking empty fields in a
printed label and recieved the answer below. I have implemented this and it
works well.
I would like to add a further feature. Having got my labels to collapse
empty cells can i make it also shrink unused length in a field?

The example is the name fields which currently have to be long enough for
the longest name eg if this fits
Miss Rebecca Fortesque
then a smaller name looks like this
Mr Rob Smith

As before any help gretfully recieved
Paul Martin

----------------------------------------------------------------------------------
If there's nothing else on the line except the single control, you can set
the CanShrink property of the control to Yes. Make sure you don't set the
Detail section to Yes or your labels will mis-align.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Rick B]

Don't put the individual fields in the label, instead, make one unbound text
box for the name and put something like the following...

=[Salutation] & " " & [FirstName] & " " & [LastName]

If you will sometimes not have the salutation, you don't want it to skip a
space. Do the following...

=([Salutation] + " ") & [FirstName] & " " & [LastName]

 

[Paul Martin]

Hi Rick,
Thanks for that. I have done it like you showed in your second example and
it works fine.

Just wondering...... Is it possible to put all the fields in an unbond text
box including line breaks? If you could and then tell it to expand or
contract the font to maximum fit in the label it would excalty match what
the dymo direct entry interface does.

Thanks

Paul

Don't put the individual fields in the label, instead, make one unbound
text box for the name and put something like the following...

=[Salutation] & " " & [FirstName] & " " & [LastName]

If you will sometimes not have the salutation, you don't want it to skip a
space. Do the following...

=([Salutation] + " ") & [FirstName] & " " & [LastName]



--
Rick B

A few days ago I asked the question below about shrinking empty fields in
a printed label and recieved the answer below. I have implemented this and
it works well.
I would like to add a further feature. Having got my labels to collapse
empty cells can i make it also shrink unused length in a field?

The example is the name fields which currently have to be long enough for
the longest name eg if this fits
Miss Rebecca Fortesque
then a smaller name looks like this
Mr Rob Smith

As before any help gretfully recieved
Paul Martin

----------------------------------------------------------------------------------
If there's nothing else on the line except the single control, you can
set
the CanShrink property of the control to Yes. Make sure you don't set the
Detail section to Yes or your labels will mis-align.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Rick B]

I think it would be something like...

=([Salutation] + " ") & [FirstName] & " " & [LastName] & chr(13) & chr(10) &
[Address1] & (chr(13) + chr(10) + [Address2]) & chr(13) & Chr(10) & [City] &
", " & [State] & " " & [Zip]


--
Rick B

Hi Rick,
Thanks for that. I have done it like you showed in your second example and
it works fine.

Just wondering...... Is it possible to put all the fields in an unbond
text box including line breaks? If you could and then tell it to expand or
contract the font to maximum fit in the label it would excalty match what
the dymo direct entry interface does.

Thanks

Paul

Don't put the individual fields in the label, instead, make one unbound
text box for the name and put something like the following...

=[Salutation] & " " & [FirstName] & " " & [LastName]

If you will sometimes not have the salutation, you don't want it to skip
a space. Do the following...

=([Salutation] + " ") & [FirstName] & " " & [LastName]



--
Rick B

A few days ago I asked the question below about shrinking empty fields in
a printed label and recieved the answer below. I have implemented this
and it works well.
I would like to add a further feature. Having got my labels to collapse
empty cells can i make it also shrink unused length in a field?

The example is the name fields which currently have to be long enough
for the longest name eg if this fits
Miss Rebecca Fortesque
then a smaller name looks like this
Mr Rob Smith

As before any help gretfully recieved
Paul Martin

----------------------------------------------------------------------------------
If there's nothing else on the line except the single control, you can
set
the CanShrink property of the control to Yes. Make sure you don't set
the
Detail section to Yes or your labels will mis-align.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Following help from this group - thanks - I can now print individual
address
labels on my label printer from with in a form.

I would like to enhance this further if possible. Is there a way to
ignore
empty fields?

The problem is that the rows in a lable are: -
Company
Title, forname, surname
address 1
address 2
City
County
Postcode
Country

so with Smiths Models, 27 A Street, Some City, 68756, Outer Mongolia I
get

Smiths Models,

27 A Street,

Some City,

68756,
Outer Mongolia

Can I make it ignore the blank lines?

Paul Martin