I would like to display a static comment "No Hints On File" if a user's password hint is left blank in database. Currently I have a <%=(rsThisUser.Fields.Item("PasswordHint".Value)%> output to the screen, but if there is no hint in the field for their record (a null in the database) the cell in the table has no value.

Try This:

<% If (rsThisUser.Fields.Item("PasswordHint".Value) = "" Then %>No hints on file<% Else %><%=(rsThisUser.Fields.Item("PasswordHint".Value)%><% End If %>




Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS

I tested the recommendation, but all we get when a null is tested is a collapsed table cell.

Another way to handle it might be to set a default value on the database table, such as 'No password hint has been stored' then when the record is created that will automatically go into the field but get overwritten when a hint in entered, that way you don't need to test

I just did something similar and worked like a charm.

Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS