Use Format in DLookup?

[tis9700]

Hi all,
I'm working with an ADP Access 2002 FE and a SQL Server 2000 BE.

Just wondering...
I'm using a Dlookup function to return a messagebox if a Social Security Number is already in use. In SQL Server it's stored with no template characters, 555555555.

On the ADP, I have an input mask 000\-00\-0000.

However, when the messagebox displays the SSN is in the format from the server with no template characters.

Can I use Format in the Dlookup function to display the SSN with the template characters, 555-55-5555?


Dlookup("studSSN", "Students_Temp", "studSSN = '" & Forms!frmStudentDataEntry.Forms!studSSN & "'")


Thanks and have a nice day!

 

[PWise]

format(Dlookup("studSSN", "Students_Temp", "studSSN = '" & Forms!frmStudentDataEntry.Forms!studSSN & "'"),"000-000-000")

 

[tis9700]

Thanks pwise! It's always the liitlethings that hold me up.