date from form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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.
Click to expand...

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