I am trying to populate a field on a form by concatinating two fileds from the first record of a table. I put the following in the fields Control Source.
=DLookUp("[ShpOrdNbr] & '-' & [ShpOrdSuf]","SOKey","ID = 1")
This works but the second field is a number and I would like to zero fill it so it shows as example 50553-003 instead of 50553-3. I tried to use the Format function but whatever I try as far as syntax causes an error.
Any help is much appreciated.
thanks...