A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form Caption Length



 
 
Thread Tools Display Modes
  #1  
Old May 7th, 2010, 11:19 PM posted to microsoft.public.access.forms
Janie
external usenet poster
 
Posts: 100
Default Form Caption Length

working in A97 ... supposedly Form Caption length max is 2048 characters ---
mine is only allowing 110 characters .. any ideas why?
  #2  
Old May 7th, 2010, 11:41 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Form Caption Length

Form Captions too long to be displayed are truncated by Access. The question
to my mind is why in the world would you need a form caption as long as or
longer than 110 characters?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

  #3  
Old May 10th, 2010, 02:21 PM posted to microsoft.public.access.forms
Janie
external usenet poster
 
Posts: 100
Default Form Caption Length

1) if HELP says the caption can be 2048 characters, than why the truncation
.... especially since the FORM is 8 inches wide -- there is ample room for a
120 character caption

2) why I need/want a longer caption is really immaterial .. but if you MUST
know, it is a positioning issue, I prefer this particular bit of caption info
(which is dynamic and changes as the user is working) to be centered on the
title bar -- better visual appeal. So, theoretical I should be able to
define my caption as Space(80) & strCaption with strCaption being a 35 to 40
character phrase. Sadly, the last 5 to 10 characters are evaporating.

So, tell me something I DON'T already know



"Linq Adams via AccessMonster.com" wrote:

Form Captions too long to be displayed are truncated by Access. The question
to my mind is why in the world would you need a form caption as long as or
longer than 110 characters?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

.

  #4  
Old May 10th, 2010, 04:40 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Form Caption Length

On Mon, 10 May 2010 06:21:01 -0700, Janie
wrote:

I prefer this particular bit of caption info
(which is dynamic and changes as the user is working) to be centered on the
title bar -- better visual appeal.


Captions tend to be static parts of the form object itself; if this is dynamic
and changeable, perhaps it would be easier to use an unbound Textbox or Label
control instead, and dynamically set its value or caption as you prefer.
Either a textbox or label can be set centered of course.
--

John W. Vinson [MVP]
  #5  
Old May 10th, 2010, 05:50 PM posted to microsoft.public.access.forms
Janie
external usenet poster
 
Posts: 100
Default Form Caption Length

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.


"John W. Vinson" wrote:

On Mon, 10 May 2010 06:21:01 -0700, Janie
wrote:

I prefer this particular bit of caption info
(which is dynamic and changes as the user is working) to be centered on the
title bar -- better visual appeal.


Captions tend to be static parts of the form object itself; if this is dynamic
and changeable, perhaps it would be easier to use an unbound Textbox or Label
control instead, and dynamically set its value or caption as you prefer.
Either a textbox or label can be set centered of course.
--

John W. Vinson [MVP]
.

  #6  
Old May 10th, 2010, 07:46 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Form Caption Length

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/For...forms/201005/1

  #7  
Old May 10th, 2010, 11:03 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Form Caption Length

On Mon, 10 May 2010 09:50:01 -0700, Janie
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]
  #8  
Old May 11th, 2010, 12:22 AM posted to microsoft.public.access.forms
Janie
external usenet poster
 
Posts: 100
Default Form Caption Length

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/For...forms/201005/1

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.