Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #9517

Re: Report determining the number of lines in a CanGrow TextBox

Show all headers | View raw

Am 14.06.2014 13:20, schrieb Phil:
> I have a report which among other things prints a person’s email address.
> The field width is limited, so in about 30% of the addresses,the Email
> address needs 2 lines. The TextBox is set to CanGrow and CanShrink and will
> hold about 22 characters. On the OnFormat of the detail, I have a routine
> that checks the length of the Email address against the width of the TextBox,
> and if it is too long, I add a linefeed before the “@” in the email address.
> Works fine except where a person’s email address is of the form
> XXXXX@YYYYYYYY.ZZZZZZZZZZ.Co.UK. Then I only get the XXXXX on the first line
> and the address spills onto the third line. So I need advice on how to
> determine if it will spill over to the third line, then I can insert the
> linefeed before the first “.”
>
> Thanks
>
> Phil
>
> ---
> This email is free from viruses and malware because avast! Antivirus protection is active.
> http://www.avast.com
>
Hi Phil,

in a report you can use the reports textheight and textwidth properties. 
In combination with the fontsize property you will be able to do the 
calculations

E.x.
me.fontsize = textbox.fontsize
count_of_rows = me.textwidth(strAddress) / textbox.width

Ulrich

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Report determining the number of lines in a CanGrow TextBox "Phil" <phil@stantonfamily.co.uk> - 2014-06-14 12:20 +0100
  Re: Report determining the number of lines in a CanGrow TextBox DFS <nospam@dfs.com> - 2014-06-14 09:11 -0400
  Re: Report determining the number of lines in a CanGrow TextBox Ulrich Möller <knobbi38@usenet.arcornews.de> - 2014-06-14 17:25 +0200
    Re: Report determining the number of lines in a CanGrow TextBox "Phil" <phil@stantonfamily.co.uk> - 2014-06-16 17:08 +0100
      Re: Report determining the number of lines in a CanGrow TextBox Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-06-16 09:31 -0700
      Re: Report determining the number of lines in a CanGrow TextBox Ulrich Möller <knobbi38@usenet.arcornews.de> - 2014-06-16 21:40 +0200
        Re: Report determining the number of lines in a CanGrow TextBox "Phil" <phil@stantonfamily.co.uk> - 2014-06-16 23:46 +0100
          Re: Report determining the number of lines in a CanGrow TextBox Ulrich Möller <knobbi38@usenet.arcornews.de> - 2014-06-17 14:29 +0200
            Re: Report determining the number of lines in a CanGrow TextBox "Phil" <phil@stantonfamily.co.uk> - 2014-06-17 16:56 +0100
              Re: Report determining the number of lines in a CanGrow TextBox Ulrich Möller <knobbi38@usenet.arcornews.de> - 2014-06-18 10:34 +0200

csiph-web