TextBoxes on a Form

N

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 ?
 
A

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 ?
Click to expand...
 
H

Harald Staff

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

HTH. Best wishes Harald
 
B

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
 
T

Tom Ogilvy

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