Me!TowFee.DefaultValue = Null -OR- Me!TowFee.DefaultValue = "" ?

[MLH]

On frmVehicleEntryForm...

I wanted to change the DefaultValue property
of one of my textbox controls on a form from within
code. I wanted the setting to be no setting - as if
nothing had ever been entered there. First, I used
Me!TowFee.DefaultValue = Null

That returned an error, so I used
Me!TowFee.DefaultValue = ""

That did not return an error. Curious, I decided to read
the A97 HELP on the subject. It said the following:

"In Visual Basic, use a string expression
to set the value of this property."

So. Does that mean if I want to set the DefaultValue property
to 0 (zero) from within VBA that the line should read

Me!TowFee.DefaultValue = "0" ???

Because I've BEEN USING
Me!TowFee.DefaultValue = 0
and this has worked for me quite nicely.

[salad]

MLH wrote:

On frmVehicleEntryForm...

I wanted to change the DefaultValue property
of one of my textbox controls on a form from within
code. I wanted the setting to be no setting - as if
nothing had ever been entered there. First, I used
Me!TowFee.DefaultValue = Null

That returned an error, so I used
Me!TowFee.DefaultValue = ""

That did not return an error. Curious, I decided to read
the A97 HELP on the subject. It said the following:

"In Visual Basic, use a string expression
to set the value of this property."

So. Does that mean if I want to set the DefaultValue property
to 0 (zero) from within VBA that the line should read

Me!TowFee.DefaultValue = "0" ???

Because I've BEEN USING
Me!TowFee.DefaultValue = 0
and this has worked for me quite nicely.

Can't you enter Null or 0 in the default box in the property sheet?

[Ed Robichaud]

For a field/control type of NUMBER, then it's Me!myField.Value = 0

For a field/control type of TEXT, then it's Me!myField.Value = "0"

-Ed
"MLH" <CR**@NorthState.net> wrote in message
news:nm********************************@4ax.com...

On frmVehicleEntryForm...

I wanted to change the DefaultValue property
of one of my textbox controls on a form from within
code. I wanted the setting to be no setting - as if
nothing had ever been entered there. First, I used
Me!TowFee.DefaultValue = Null

That returned an error, so I used
Me!TowFee.DefaultValue = ""

That did not return an error. Curious, I decided to read
the A97 HELP on the subject. It said the following:

"In Visual Basic, use a string expression
to set the value of this property."

So. Does that mean if I want to set the DefaultValue property
to 0 (zero) from within VBA that the line should read

Me!TowFee.DefaultValue = "0" ???

Because I've BEEN USING
Me!TowFee.DefaultValue = 0
and this has worked for me quite nicely.

[MLH]

Yes, I can - manually. Perhaps from VBA, I should use "Null"???

Can't you enter Null or 0 in the default box in the property sheet?