VBA yet again again again

[coox]

Don't you just hate VBA?
Anyway, I don't suppose anyone knows how to stop the title bar or a form displaying, do you, eh, do you? I bet Marty knows...

[Serge]

You cannot remove the Title (Caption) of the form because Access would show the form name by default. But you can fake it. For caption you can put a "SPACE". It will look like the form doesn't have the caption. If you meant something else, please rephrase.

Regards,

------------------

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com
ICQ#: 51055819 (http://www.icq.com/51055819)

[coox]

Hi Serge, I was hoping to do away with the caption bar and X (close thing) altogether, like you can in, say, VB5. Sounds like it's not poss though eh?

[Yonatan]

WhatToDo = Choose(1, "Buy ", "Rent ") & Left("VBA", 2) & String(3, "!")

Aside from that, I don't think it's possible... Microsoft customized their UserForms so much, it's impossible to do many things with those pieces of junk... (I tried to remove the title bar! It won't go away no matter what!)

------------------
Yonatan
Teenage Programmer
E-Mail: RZvika@netvision.net.il
ICQ: 19552879 (http://www.icq.com/19552879)

[MartinLiss]

Sorry, but unfortunately (fortunately?) I don't use VBA.

------------------
Marty

[Serge]

Actually, your VBA doesn't do any good, because you can't compile your stand alone EXE. But if you Do need the compiler for the MS Office then you would have to buy MS Ofice Developers Edition which does have compiler, but it's pricey ($600-$800). For that much money you'll be better off with buying VB.

Regards,

------------------

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com
ICQ#: 51055819 (http://www.icq.com/51055819)

[coox]

Thanks Yonataon, you old comic you. But need I really BUY VB when there are so many dodgy copies about? OOOOOHHHH!!! Heresy. Just kidding. So it's game over eh? I'll just have to put up with what I've got. Dammit (that wasn't swearing, that was some kind of German word I think)