Change the size & title of an inputbox 1

[hdgirl]

How do i make an inputbox smaller & change the title? i have tried to change it in the same way that you would change a messagebox title but VBA does'nt like it... CJB

 

[Gazer44]

what type of input box is it & what's it for
(i.e. on a Parameter query asking for criteria or something else?)

 

[hdgirl]

To open a specified record (not parameter) CJB

 

[HHaskel]

If you mean an inputbox like this:

MyValue = Inputbox("Promt here!","Title here!&quot

Then you can set the title as above. If you want to change the size I think it gets a bit more complicated.

Maybe you can use a separate form instead.


Hakan Haskel

 

[hdgirl]

This worked fine thanks Hakan CJB