TextBoxes on a Form

[Neil]

Hi, I have a form with a lot of textboxes on it, they are
confirgured as Borderstyle single, and are right next to
each other so that it looks like a spreadsheet, at form
load I do a loop around some values ex a query from an
external data source and populate the textboxes down the
left hand side, to prevent people from changing the data
in these textboxes I have set them as Enabled = False.
But this causes the text to become grey, is there any way
I can keep the text black but prevent the contents of the
textbox from being changed ?

 

[Andy Pope]

Hi Neil,

Try the Locked property.

Cheers
Andy

Hi, I have a form with a lot of textboxes on it, they are
confirgured as Borderstyle single, and are right next to
each other so that it looks like a spreadsheet, at form
load I do a loop around some values ex a query from an
external data source and populate the textboxes down the
left hand side, to prevent people from changing the data
in these textboxes I have set them as Enabled = False.
But this causes the text to become grey, is there any way
I can keep the text black but prevent the contents of the
textbox from being changed ?

 

[Harald Staff]

Another trick is to place them onto a Frame and set the Frame Enabled to
False.

HTH. Best wishes Harald

 

[Bob Flanagan]

Neil, you can also put them in a label and use chr(13) to do a line return
so that each entry is on a new line.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Tom Ogilvy]

You can replace your textboxes with labels. Labels can be formatted to look
like your textboxes.