Link to home
Create AccountLog in
Microsoft Access

Microsoft Access

--

Questions

--

Followers

Top Experts

Avatar of developingprogrammer
developingprogrammer

autosize label Access 2007
hey guys, i'm trying to autosize my label so that it can fit the captions which are set in runtime. how can i do so? i can't seem to find autosize property anywhere in the label! thanks guys!!

User generated image

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of IrogSintaIrogSinta🇺🇸

I am not aware of any autosize property for a label.  Why not just make it as a large as the longest caption you would put in there?

Avatar of developingprogrammerdevelopingprogrammer

ASKER

Cause I wanna highlight the back colour of the label red if the validation fails. So if it's longer than the caption it looks a bit funny ha = )

Avatar of IrogSintaIrogSinta🇺🇸

It may not look so bad if you center-justify the label.  Another option would be to revise the label width property accordingly when you update the caption.  A third option would be to change the font color instead.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


how do i revise the label width property when i update the caption?

as in, how do i know how wide to set the label width? thanks IrogSinta!

SOLUTION
Avatar of IrogSintaIrogSinta🇺🇸

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Oh my goodness. That's a bit extreme haha, but at least I know now = ) probably one solution is to multiply it by characters keeping a constant font. But that depends on the font as well if the characters are equal width, which usually is not considering "i" and "w"

But thanks so much for your help IrogSinta!! = ))

SOLUTION
Avatar of mbizupmbizup🇰🇿

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.

SOLUTION
Avatar of mbizupmbizup🇰🇿

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.

ASKER CERTIFIED SOLUTION
Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.

whao super cool mbizup and DatabaseMX, let me go through this question again (as in your sharings) then close it ya, i think got a bit for me to digest and try out = )

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


haven't had time to try and implement this yet guys but am saving it in my personal knowledge on EE = )

i think Lebans is one site i need to go through in totality as well.

thanks guys and apologies for the late closure!!

"i think Lebans is one site i need to go through in totality as well."
Definitely!  I have every example from his site ... just in case it goes away. A total gold mine of cool and unusual stuff.

Same for Allen Browne.

And for sure Leigh Purvis's site:

http://databasedevelopment.co.uk/examples.htm
I have every example form here also. Some GREAT concepts demonstrated.

mx

Whao super cool mx! I'm going there now to bookmark it! Thanks!! = ))

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Microsoft Access

Microsoft Access

--

Questions

--

Followers

Top Experts

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.