Form Field Formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bw - 27 Mar 2006 00:20 GMT

I have a Form Field on my document.
The properties are as follows:
Type: Number
Default number:
Maximum Length: 15
Number Format: ### #### #### ####

This format is causing me some problems, as the number uses the proper
format, but is LEFT justified. I want the format to be used but with the
number being RIGHT justified.

Example of what I don't want, but is what I'm getting: 123 45
Example of how I want the number to look: 1 2345

Can someone explain how to accomplish this?

Thanks,
Bernie

Reply to this Message

Doug Robbins - Word MVP - 27 Mar 2006 05:02 GMT

Run a macro containing the following code on exit from the formfield:

With ActiveDocument.FormFields("text1")
.result = Format(.result, "### #### #### ####")
End With

where "text1" is the name of the bookmark assigned to the formfield, which
should be changed back to a text type.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a Form Field on my document.
> The properties are as follows:
[quoted text clipped - 14 lines]
> Thanks,
> Bernie

Reply to this Message

bw - 27 Mar 2006 09:10 GMT

Excellent Doug!
Just what I was looking for...

On another subject, is there and On_Open event in Word, and if so, how do I
"set it up"?

Thanks,
Bernie

> Run a macro containing the following code on exit from the formfield:
>
[quoted text clipped - 22 lines]
>> Thanks,
>> Bernie

Reply to this Message

Doug Robbins - Word MVP - 27 Mar 2006 18:24 GMT

If you have a macro named Autoopen() in the template from which the document
is created, that macro will run when the document is opened.

See the article "Running a macro automatically when a document is created,
opened or closed" at:

http://www.word.mvps.org/FAQs/MacrosVBA/DocumentEvents.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Excellent Doug!
> Just what I was looking for...
[quoted text clipped - 31 lines]
>>> Thanks,
>>> Bernie

Reply to this Message

bw - 27 Mar 2006 20:27 GMT

Thanks again, Doug
Great information you have provided.

Bernie

> If you have a macro named Autoopen() in the template from which the
> document is created, that macro will run when the document is opened.
[quoted text clipped - 39 lines]
>>>> Thanks,
>>>> Bernie

Reply to this Message