Bookmark format

[Guest]

Hi.
I have a numeric field which increase with each record ('1', '2', ...).
However, I want '1' to appear as '001'; for that, I went to the field format
and entered '000'. And that worked.
Now I have a bookmark in a Word template that shows that numeric value, but
the value appears as '1' instead of '001' (in the Word document).
Can anybody tell me how can I fix that? Is this a problem for Access or for
Word?
Thank you in advance.
Regards.

 

[John Vinson]

Hi.
I have a numeric field which increase with each record ('1', '2', ...).
However, I want '1' to appear as '001'; for that, I went to the field format
and entered '000'. And that worked.
Now I have a bookmark in a Word template that shows that numeric value, but
the value appears as '1' instead of '001' (in the Word document).
Can anybody tell me how can I fix that? Is this a problem for Access or for
Word?
Thank you in advance.
Regards.

Exports - to text files, Word, or whatever - do not carry the Format
property of the field with them.

Use a query with a calculated field converting this number field to
Text:

ExpField: Format([numberfield], "000")

and use it in your merge rather than the number field itself.

John W. Vinson[MVP]

 

[Guest]

Hello, John Vinson.
Thank you for your help. It worked just fine.
Best regards.
Acores

"John Vinson" escreveu:

Hi.
I have a numeric field which increase with each record ('1', '2', ...).
However, I want '1' to appear as '001'; for that, I went to the field format
and entered '000'. And that worked.
Now I have a bookmark in a Word template that shows that numeric value, but
the value appears as '1' instead of '001' (in the Word document).
Can anybody tell me how can I fix that? Is this a problem for Access or for
Word?
Thank you in advance.
Regards.

Exports - to text files, Word, or whatever - do not carry the Format
property of the field with them.

Use a query with a calculated field converting this number field to
Text:

ExpField: Format([numberfield], "000")

and use it in your merge rather than the number field itself.

John W. Vinson[MVP]