Using Tabs Characters in Labels Controls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eddie's Bakery and Cafe' - 01 Mar 2005 20:41 GMT

Can someone please tell me how to use the vbTab character? I am trying to
format a label using tabs. When I add the vbTab to the string it prints a
squares instead of tabbing the text over.

This is what I am doing:

str = vbTab & “ some text”
Me!lable.Caption = str

Thanks,

Eddie Eytchison

Reply to this Message

Dirk Goldgar - 01 Mar 2005 21:52 GMT

> Can someone please tell me how to use the vbTab character? I am
> trying to format a label using tabs. When I add the vbTab to the
[quoted text clipped - 4 lines]
> str = vbTab & " some text"
> Me!lable.Caption = str

No matter what you do, it's not going to work. You have to insert an
appropriate number of spaces instead.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Eddie's Bakery and Cafe' - 01 Mar 2005 23:11 GMT

that's too bad, maybe micorsoft will do someting about this in a later
release.

Once again, thanks for al you help!!!

Eddie Eytchison

> > Can someone please tell me how to use the vbTab character? I am
> > trying to format a label using tabs. When I add the vbTab to the
[quoted text clipped - 7 lines]
> No matter what you do, it's not going to work. You have to insert an
> appropriate number of spaces instead.

Reply to this Message

Dirk Goldgar - 02 Mar 2005 05:55 GMT

> that's too bad, maybe micorsoft will do someting about this in a
> later release.

Maybe, but I rather doubt it. I haven't seen much demand for it. If
you don't mind my asking, what are you trying to accomplish? Maybe
there's a better way to do it.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Eddie's Bakery and Cafe' - 02 Mar 2005 15:47 GMT

Hi Dirk, Not at all, recently I retired after spending 20 years in the
software industry. I live in San Jose, Ca. and now I'm learning how to bake
(I have been going to culinary school for this). I plan on opening a
bakery/café with my daughters hopefully later this year. The MS Access
application I am developing is for the bakery. I am adding help screens to
the application. This is why I need special characters for formatting text.
As you probably know, most people in the food service business don’t have a
great understand of technology and by adding help screens; I hope to make the
application more “user-friendly”

Thanks for your interest,

Regards,

Eddie Eytchison

> > that's too bad, maybe micorsoft will do someting about this in a
> > later release.
>
> Maybe, but I rather doubt it. I haven't seen much demand for it. If
> you don't mind my asking, what are you trying to accomplish? Maybe
> there's a better way to do it.

Reply to this Message

Brendan Reynolds - 02 Mar 2005 16:04 GMT

I use HTML pages for my help screens, Eddie. I can format them as I want,
incorporate screen-shots as images, and provide links to related topics. You
can display them easily from your Access forms using the FollowHyperlink
method.

Here's an example of the code behind one of my 'Help' command buttons. This
code assumes that the help page for this form has the same name as the form,
but with a .htm extension, and that it lives in a 'help' subfolder off the
folder in which the application lives ...

Dim strHelpURL As String

strHelpURL = CurrentDb.Name
strHelpURL = Left$(strHelpURL, Len(strHelpURL) - Len(Dir(strHelpURL)))
strHelpURL = strHelpURL & "help\" & Me.Name & ".htm"
Application.FollowHyperlink strHelpURL

Signature

Brendan Reynolds (MVP)

> Hi Dirk, Not at all, recently I retired after spending 20 years in the
> software industry. I live in San Jose, Ca. and now I'm learning how to
[quoted text clipped - 23 lines]
>> you don't mind my asking, what are you trying to accomplish? Maybe
>> there's a better way to do it.

Reply to this Message

Eddie's Bakery and Cafe' - 02 Mar 2005 16:21 GMT

Hi Brendan, Thanks for the tip, I will give it a try

> I use HTML pages for my help screens, Eddie. I can format them as I want,
> incorporate screen-shots as images, and provide links to related topics. You
[quoted text clipped - 40 lines]
> >> you don't mind my asking, what are you trying to accomplish? Maybe
> >> there's a better way to do it.

Reply to this Message