Hello
Not familar with Asp but I am very familiar with ASP.NET.
When a database column, Status, has string ='enrolled' all the textboxes on the form (over 50 textbox) property should be readonly. What is the best way to do this?
Some examples please. Thank you

I assume you mean textArea? Dont know if its the 'best way' but I would:

1..get records
2..Assign a true false state to variable:
dim disableTxtArea
disableTxtArea = false
IF rs("status") = "enrolled" then disableTxtArea = true END IF
3..Now assign it accordingly, EG:
<textArea <%if disableTxtArea then%> disabled <%end if%></textArea>

IMO disabled is better than read only. Read only does not dim the text, users think there is a problem on the page. Disabled dims the text and makes it clear that 'there is something different about these textAreas'.

You have the string 'enrolled' in a column, this is poor normalization. I would have a tables called status. Enrolled apears in there once and links to your main table, this way a single integer represents an enrolled status. This way you can add to the status tble using a cms page etc.....



Wind is your friend
Matt