1st let me tell you what I have done, and then what I am having problems
with. I have a form with a field called IRD. IRD is a date format of mmmm
dd","yyyy and it shows in the form okay, but now I need to put it in a word
doc. When I add the bookmard it comes up with mm/dd/yy. I have a script to
import it, and this is where I think my promble is. here is the script.
If IsNull(Forms![in-house r&d]![IRD]) Or Forms![in-house r&d]![IRD] = "" Then
prompt = MsgBox("The Issue Date has not been entered", vbOKOnly)
Else
.activedocument.Bookmarks("IRD").Select
.selection.Text = (CStr(Forms![in-house r&d]![IRD]))
.activedocument.Bookmarks.Add Name:=("IRD")
End If
see it is taking it as ".selection.text" , but I tried ".selection.date" but
again I have come up with errors. can someone please help in this matter. I
have spent to long on this and I am running out of hair to pull....LOL..
thanks.

Hello "chris" (?).

"chris_s_walters" wrote:
> 1st let me tell you what I have done, and then what I am having
> problems with. I have a form with a field called IRD. IRD is a date
> format of mmmm dd", "yyyy and it shows in the form okay, but now
> I need to put it in a word doc. When I add the bookmark it comes
> up with mm/dd/yy. I have a script to
> import it, and this is where I think my promble is. Here is the script.
> If IsNull(Forms![in-house r&d]![IRD]) Or Forms![in-house r&d]![IRD] _
> = "" Then
> prompt = MsgBox("The Issue Date has not been entered", vbOKOnly)
> Else
> .activedocument.Bookmarks("IRD").Select
> .selection.Text = (CStr(Forms![in-house r&d]![IRD]))
> .activedocument.Bookmarks.Add Name:=("IRD")
> End If
> see it is taking it as ".selection.text", but I tried ".selection.date"
> but again I have come up with errors. can someone please help in
> this matter. I have spent to long on this and I am running out of hair
> to pull....LOL.. thanks.

Try this:
..selection.Text = _
FOrmat$(CStr(Forms![in-house r&d]![IRD])),"mmmm dd"","" yyyy")

--
Regards,
Wolfgang