Control Source Problem

  • Thread starter Thread starter Sondra
  • Start date Start date
S

Sondra

I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
..
 
I used your suggest and it just continues to error out.
-----Original Message-----
= "CM020-" & Format([Year],2) & "-" & Format ([CM_Number],000)


--
Ken Snell
<MS ACCESS MVP>

Sondra said:
I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
.
Click to expand...


.
Click to expand...
 
Which error?

--
Ken Snell
<MS ACCESS MVP>

I used your suggest and it just continues to error out.
-----Original Message-----
= "CM020-" & Format([Year],2) & "-" & Format ([CM_Number],000)


--
Ken Snell
<MS ACCESS MVP>

Sondra said:
I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
.
Click to expand...


.
Click to expand...
Click to expand...
 
Noted that I didn't add all the correct " characters. Try this:

= "CM020-" & Format([Year], "00") & "-" & Format([CM_Number], "000")
--
Ken Snell
<MS ACCESS MVP>

I used your suggest and it just continues to error out.
-----Original Message-----
= "CM020-" & Format([Year],2) & "-" & Format ([CM_Number],000)


--
Ken Snell
<MS ACCESS MVP>

Sondra said:
I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top