>How can I pad an expression (character or numeric) with a character?
>
>For example:
>
>I want to store 1 as 0001
>
>In VFP the syntax is padl(expression,4,'0') but obviously this didn't work in Access. Any help would be appreciated

If I remember correctly you work with A2000 right? There is a string function which will help you get at the desired result:

sPadded = String(4 - Len(sNoPad), "0") & sNoPad

Assumming that sNoPad is a string variable. HTH