VBA text posting and conditional formatting

[NejcZ]

Hello everyone.
In my app, I have several Access to Word functions, creating different documents. For that, I'm using bookmarks like this:

.Goto what:=wdGoToBookmark, Name:="wproductNumber"
.TypeText [productNumber]

Basically, I want to know, if it's possible to post current date the same way as productNumber mentioned above?
Also, I was searching all over, but couldn't find it..
I want to add red background to textbox, which contains let's say more than 5 numbers/characters. Any sample code or suggestion?

Thanks!

[June7]

I don't know. Can the bookmark accept result of a function?

.CurrentDate Date()


You want to add red background to textbox where - in Word?

[NejcZ]

In brackets [] it doesn't work.
I want to add red background to textfield in Access form.

[June7]

Brackets are not used with function call. Date() is an intrinsic function.

Consider textbox Conditional Formatting to manage the back color. Expression like:

Len([fieldname])>5

[NejcZ]

Thanks, that worked. I was forgetting fieldname in my expressions...
But for the data, it won't work.

.Goto what:=wdGoToBookmark, Name:="wdatum"
.CurrentDate Date()

If i put that in my code it removes () at the end.


edit:
got it solved like that:

Dim currDate As Date
currDate = Date()

.Goto what:=wdGoToBookmark, Name:="wdatum"
.TypeText [currDate]

Thanks for your help.