number format

[siculster]

I have two fields, one named course code and one named requisition number. I have both of them in a text field:

=[Course code] & [Requisition no]

Requisition number is an autonumber with a format of "/000"

The problem is that if course code = 185 and requisition number = 010

it displays:

18510 instead of 185010

How can i format this in a form?

Thanks

 

[dcx693]

If the course code is always three digits, then use this:
=[Course code] & Format([Requisition no],"000")

 

[siculster]

Thanks mate - i feel stupid!