Formatting text box on a Report

[nthompson]

I am attempting to format a text box which is based on the field Account_# from a query. In the control source I have: =MaskAccount([Account_#])

MaskAccount is the following function:

Public Function MaskAccount(strAccount As String) As String
MaskAccount = "xxxxxxxxxxxx" & Right(strAccount, 4)
End Function

On my report I get #Error.

Any suggestions??

 

[Maquis]

One thing to check. Is [Account_#] a text field? It's name implies a number type field, yet you are passing it as a string. Maq B-)
<insert witty signature here>

 

[nthompson]

[Account_#] is a text field.