Hi,
I'm relatively new to VBA/Access. I have a field (text format) which contains items (of about 5000) of length 12 or 13 in an Access table. I want to prefix a "0" before all items having a length of 12 to make it 13. How can I do that? Where should i do that?? I tried putting an IF statement in VBA editor, but returned with syntax error. Please help
Thanks
Soorya

Try:
if len(strText) = 12 then
    strText = "0" & strText
end if

Cheers Ray

Thanks Ray. I was trying to implement similar logic in Access, but had a hard time getting reference to field in Access table and update it with this logic.