string problem

[pertotal]

I'm breaking my head on a stupid problem :

I have an If then else structure with a string comparison,
I want to show a msgbox when a certain string is empty : null value. If I use me![string] = "" it won't work.

another question on the use of a message box :

I want to use a variable field + text in a message box, how do I use the syntax :

Msgbox([string] & "blablablabla!&quot

how do I make this work?

thnx in advance

 

[mailzero28]

Try this

If IsNull(Me![String]) then

Hope this helps,

bye

Martin

 

[jgoodman00]

"" is a zero length string, which is not null. To test for 'nullness' you need to use the IsNull function.

As for the other part, you just need to reference it in correctly. e.g
msgbox ("The value in field has been changed to " & me.fieldname & ". Are you sure?&quot

James Goodman
j.goodman00@btinternet.com

 

[pertotal]

thanx for the quick response : it works