My code doesn't wants to set the control default value

[Mihail]

Hello !
I know that is very unusual to do what I do now.

But, are you so kind to take a look to this thread on other forum ?
Hope someone have a idea.

Thank you !

 

[pr2-eugin]

The reason I could think of is. Form Open is very early for setting this.. Try the Form Load.. You mention using Form Load everywhere but your code shows Form_Open

 

[Mihail]

Thank you for reply, Paul.

The reason I could think of is. Form Open is very early for setting this.. Try the Form Load.. You mention using Form Load everywhere but your code shows Form_Open

I've tried this. Same result.

 

[JHB]

It needs to surrounded by quotes like:

.DefaultValue = """" & Me.OpenArgs & """"

Also look at the field size in the table, (or post some sample database).

 

[Mihail]

Ufff, JHB.
That is. Thank you !

Works with double quotes as you say and even with single quotes:

Me.Tip.DefaultValue = "'" & Me.OpenArgs & "'"

Thank you again !

 

[JHB]

You're welcome. (If the field size is to short, you'll get the same error.)