format zipcode in form

[Slush]

I need to format zip codes in a form as either 5 characters or 9 characters with a dash. The data in the field do not contain dashes. I have tried the following code in the unbound control source of the form, but neither work.

=IIf(Len([Zip])>=6, Left([Zip],5) & "-" & Right([Zip],4),[Zip])




=IIF(Len(zip)=6, Left(zip,5),IIF(Len(zip)=9,Format(Zip,"@@@@@-@@@@"),Zip))

[John_G]

When you say neither one works, what do you mean? Is anything displayed, and if so what does it look like? I don't see anything wrong with the expressions, especially the first one.

[Missinglinq]

...I have tried the following code in the unbound control source of the form, but neither work...

First off, Forms don't have Control Sources...Controls have Control Sources!

Are you saying that you're using the first expression in the Control Source of an unbound Control? Or are you trying it in the Control Source of the Zip Textbox? If the former, it should work, assuming that the Control Name is actually Zip, and not something like txtZip.

The second expression won't work, in the Control Source, because Zip would need to have Square Brackets around it (as in your first example) when used like this in a Control Source.

Linq ;0)>