How can I center the form caption, eg me.form.caption = "Hello"

[trevor40]

Is it possible to place the form caption in the center of the form eg



Me.Caption = "All entries for - " & DLookup("[company title]", "[application data]", " [company title] = forms![main menu]![combo1290] ")

Display's All entries for - Company Name Here

that works fine but it's aligned left in the form's title bar, I'd like to align it to center, can this be done in Access 2003 or WindowsXP?
Just tweeking the general apperence a little and noticed this would look better centered.
ps I have tried padding the front of the caption with spaces, it does sort of work but looks a bit odd as the text length changes.

[June7]

I don't know of an alignment option for the form header bar. Could maybe type a bunch of spaces in front of "All".

[trevor40]

That's what i'm doing now, just looks a bit odd when the names change!

[June7]

MS probably figured centering is not a good idea because if user is allowed to resize form width, the centered title might not show.

[pbaldy]

You might check out the Space() function to dynamically adjust the number of spaces. I'm curious why you use the DLookup(), as it appears the desired value is in the combo.

[trevor40]

Good point, I'll check on the usage of that.

[trevor40]

Thanks Pbaldy, that was an incorrect reference, it should be...
Me.Caption = "All entries for - " & DLookup("[company title]", "[application data]", " [company title] = forms![main menu]![setup options]![combo1290] ")

[June7]

Same question. Why DLookup for company title if company title is already in the combobox?

Me.Caption = "All entries for - " & Forms![main menu]![setup options]![combo1290]

Glad Paul remembered the Space() function.

[trevor40]

Good point. I'll look into it...yep, Thanks for that, it will help speed things up with less dlookup's.
still looking at the space() function.

[trevor40]

Just tried the Space(x) function, I have found that there is not enough space in the titla bar for this, it starts to blank out the end of the text if Space(50) is added to the caption.
I'll just have to live with it.

[pbaldy]

I was thinking more like

Space(x - Len(CompanyName))

where x was an appropriate value that resulted in the desired look as the length of the name changed.

[trevor40]

This has the same problem, runs out of room and cuts of the end. thanks anyway, I'm going to live with for now.

[pbaldy]

I would think that would depend on proper choice of x, but I've never actually tried it.

[June7]

I just tested. My caption was only "MAIN". It works until I tried 129 as x. Only shows "MAI".

[trevor40]

I gave up on that one, I've moved onto designing some reports form them now. Just posted a Question about creating dynamic reports.