Auto Numbers In a Form wont show format from Table

[jbeling]

I have a table with an auto number and its format is:

\R000"08"

My goal was to have an auto number where it looks like R00108 and only the 3 digits between the R and the 08 change. The above format enabled me to do so.

THe problem is that in the Form i am making, it will only show the digit of the record that will auto populate in my table, or So instead of showing R00708 for record 7 it shows just 7. I put an imput conrtol in the properties of the text box but then it just showed R 708 and leaving the 2 zeros before the 7 off completley.

Any suggesstions?

 

[pbaldy]

Presuming you just have numbers in your field, you can display it on a form with:

="R" & Format(YourFieldName, "000") & "08"

 

[jbeling]

Presuming you just have numbers in your field, you can display it on a form with:

="R" & Format(YourFieldName, "000") & "08"

I did that at it just changes it on me to:

"=R "&" Form"a"t(ID"," 000) "&" 08"

 

[pbaldy]

Where exactly did you put it? It was intended to be the control source of a textbox.

 

[RuralGuy]

jbeling:
Here's a link containing information of which you should be aware.
http://www.mvps.org/access/general/gen0025.htm

 

[jbeling]

I have seemed to figure this out. I was gong about it all wrong. Thank you guys! You were all a big help!