coding problem

[deepaksharma]

I have done coding in the student name box of this program under which when the cursor goes to this box and this box is empty then the message of "hello" should come but it is not coming.

[CJ_London]

Looks like a continuation of this thread
https://www.accessforums.net/showthr...231#post516231

[mike60smart]

Try this:-



Private Sub Student_Name_GotFocus()


If (IsNull(Me.Student_Name)) Then


MsgBox "Enter a name", vbCritical
End If


End Sub

But can you also explain why you need to do this?

[deepaksharma]

thanks.. it working
what was the difference between you coding and mine?
My main reason is other it's just a sample program...

[deepaksharma]

Looks like a continuation of this thread
https://www.accessforums.net/showthr...231#post516231

That was another problem involving numeric and string problems which had been solved.

[mike60smart]

This line:-

If (IsNull(Me.Student_Name)) Then

[deepaksharma]

This line:-

If (IsNull(Me.Student_Name)) Then

yes it worked
but i asking that what is difference between in this

if (IsNull(Me.Student_Name)) then
and
if Me.Student_Name.Value = Null then

[mike60smart]

Well

= Null does not work

[Welshgasman]

yes it worked
but i asking that what is difference between in this

if (IsNull(Me.Student_Name)) then
and
if Me.Student_Name.Value = Null then

Nohing is equal Null, that is beauty of Null.

[deepaksharma]

Nohing is equal Null, that is beauty of Null.

[deepaksharma]

what is difference in this_____

if (IsNull(Me.Student_Name)) then
and
If (IsNull(Me![Student_Name].Value)) Then
and
If Me.Student_Name = "" Then

Please explain any expert......

[Welshgasman]

.Value is the default property for a control so first two are the same.
Null is not = "" (already told you that), hat is called a Zero Length String (ZLS)

You could try

If Me.Control & "" = "" Then

or test same for Length = 0

Not an expert, but thought I'd have a punt.

[Micron]

The first two are quite similar but for the use of Me! vs Me.
Me! will not compile and will only evaluate at run time. If what follows ! cannot be resolved (e.g. due to a spelling error) it will only trigger an error when it tries to execute that line.

[deepaksharma]

thansk to all....