|
You can format field values by adding ASP code.
Input value is stored in the variable strValue. Output value is assigned to
the same variable strValue. You can access other fields
of the same data record as rs("FieldName").
Examples:
1. Convert a string into the upper case:
|
strValue = Ucase(strValue)
|
2. Format 10-digit phone number into the following format (xxx)
xxx-xxx:
|
if
Len(strValue)=10 then
strValue = "("
& Mid(strValue,1,3)
& ") "
& Mid(strValue,4,3)
& "-"
&
Mid(strValue,7)
end if
|
3. Display value of field FirstName as <FirstName> <LastName> (if
LastName field
defined):
|
strValue = strValue & " " & rs("LastName")
|
4. Display a number in black color if number is positive and red
font if number is negative:
|
if CDbl(strValue)>0 then
color="black"
else
color="red"
end if
strValue= "<font color='" & color & "'>" & strValue & "</font>"
|
5. Display a field containing email address as email hyperlink
(mailto function used). The
value of subject in mailto
function is set to a value of another field:
|
strValue = "<a href='mailto:" & strValue & "?subject=" & rs("SubjectField") & "'>Send email</a>"
|
6. Display a field value in one line (without line breaks):
|
strValue =
Replace(strValue, " "," ")
|
|
