Prev: Use Parameter Data to populate a form field
Next: Expression in forms
From: BruceM via AccessMonster.com on 10 May 2010 14:46
In Access 2003 I can't find information in Access Specifications about the
length of the form caption. I see that labels are limited to 2048 characters,
but nothing about the form caption. However, some additional checking
suggests that any caption property, including the form caption, is limited to
2048 characters.

In my experiments I discovered that the form caption seems to be a bit quirky.
If there are a lot of leading spaces, the right side is truncated by what
seems to be a similar amount of space as on the left side, but not as much if
it is all text (i.e. without the Space function). From what I can tell,
spaces are the only way to center the caption. Here is a code way to
calculate spaces:
http://www.applecore99.com/api/api017.asp
I found it in a brief search, but have not tested it, and make no claims
about the method.

In responding I realize I run the risk of having you get snippy at me too,
but I was curious and did some investigating, the limited results of which I
decided to pass along. The bottom line is that I don't know why it behaves
as it does, but I would just point out that a form with a caption that
includes leading spaces may show up as blank in the windows task bar, which
may or may not be an inconvenience for users.

I was going to suggest that you set the Border Style to None, and use a text
box to simulate the title bar. You can probably even simulate the control
box buttons (Min, Max, Close), but you will need to write code for them.
However, it is probably among the "workarounds galore" you have already
considered.


Janie wrote:
>well, then it isn't in the Title Bar, then is it?
>
>Also, since the Form Caption supposedly can be up to 2048 characters, I have
>yet to hear a reasonable explanation why an 8 inch wide form is dropping
>everything after the 110th character .. which is the orignal question.
>
>I can come up with workarounds galore that do not involve the Title Bar or
>the Form Caption property ... but that is not satisfying the question nor the
>intellectual curiosity to understand this behavior.
>
>> >I prefer this particular bit of caption info
>> >(which is dynamic and changes as the user is working) to be centered on the
>[quoted text clipped - 4 lines]
>> control instead, and dynamically set its value or caption as you prefer.
>> Either a textbox or label can be set centered of course.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1

From: John W. Vinson on 10 May 2010 18:03
On Mon, 10 May 2010 09:50:01 -0700, Janie <Janie(a)discussions.microsoft.com>
wrote:

>but that is not satisfying the question nor the
>intellectual curiosity to understand this behavior.

Sorry, I haven't played around with the form Caption property at all and don't
have any idea why it's doing this.
--

John W. Vinson [MVP]
From: Janie on 10 May 2010 19:22
Now that is something interseting ... I had already experimented with spaces
as
character strings (sans Space function) and had the same effect. Also, the
string never started with spaces -- there was always charatcers followed by
spaces followed by characters followed by spaces followed by characters ...
and always dropped after 110. The only time this did not happen was if the
string was continuous with no spaces either as in " My String" or in
string(8," ") or in space(8) ... only if the string was something like
string(255,"x").

The Help states:
"The Caption property is a string expression that can contain up to 2,048
characters. Captions for forms and reports that are too long to display in
the title bar are truncated."

But I have yet to find a definitive rule on what is considered "too long".

Snippy? No dear, withering. I am an old time professor out of the
Kingsfield mold.





"BruceM via AccessMonster.com" wrote:

> In Access 2003 I can't find information in Access Specifications about the
> length of the form caption. I see that labels are limited to 2048 characters,
> but nothing about the form caption. However, some additional checking
> suggests that any caption property, including the form caption, is limited to
> 2048 characters.
>
> In my experiments I discovered that the form caption seems to be a bit quirky.
> If there are a lot of leading spaces, the right side is truncated by what
> seems to be a similar amount of space as on the left side, but not as much if
> it is all text (i.e. without the Space function). From what I can tell,
> spaces are the only way to center the caption. Here is a code way to
> calculate spaces:
> http://www.applecore99.com/api/api017.asp
> I found it in a brief search, but have not tested it, and make no claims
> about the method.
>
> In responding I realize I run the risk of having you get snippy at me too,
> but I was curious and did some investigating, the limited results of which I
> decided to pass along. The bottom line is that I don't know why it behaves
> as it does, but I would just point out that a form with a caption that
> includes leading spaces may show up as blank in the windows task bar, which
> may or may not be an inconvenience for users.
>
> I was going to suggest that you set the Border Style to None, and use a text
> box to simulate the title bar. You can probably even simulate the control
> box buttons (Min, Max, Close), but you will need to write code for them.
> However, it is probably among the "workarounds galore" you have already
> considered.
>
>
> Janie wrote:
> >well, then it isn't in the Title Bar, then is it?
> >
> >Also, since the Form Caption supposedly can be up to 2048 characters, I have
> >yet to hear a reasonable explanation why an 8 inch wide form is dropping
> >everything after the 110th character .. which is the orignal question.
> >
> >I can come up with workarounds galore that do not involve the Title Bar or
> >the Form Caption property ... but that is not satisfying the question nor the
> >intellectual curiosity to understand this behavior.
> >
> >> >I prefer this particular bit of caption info
> >> >(which is dynamic and changes as the user is working) to be centered on the
> >[quoted text clipped - 4 lines]
> >> control instead, and dynamically set its value or caption as you prefer.
> >> Either a textbox or label can be set centered of course.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Use Parameter Data to populate a form field
Next: Expression in forms