Visible data with If/Then

[jpr]

Hello,
I have a form with twa txtboxes named mytxt and txtresult.

The txtresult gets its data from a module (GetInterval).

I have written this statement:

If IsNull (Me.mytxt) then
Me.txtresult) = Null

I get an error as if that control cannot contain null values.

I have done the same with another sample, simply changing the record
source of my txtresult to a field of my table and works?

can anyone see the problem?

I have also tried in with this code but still nothing:

If Len(Trim$(Me!USER & vbNullString)) = 0 Then

Thanks.

[Wayne Morgan]

How does txtResult get its data from the module? What is the Control Source
of txtResult? If txtResult is bound to a field, is the field defined in the
table as Nulls not allowed (i.e. Required = Yes)? Where is the module
located, is it in the form that has these two textboxes? What is the error
that you get?

There are two typos in the example you gave (a space after IsNull and an
extra ")"), it should be:

If IsNull(Me.mytxt) Then
Me.txtresult = Null
'other lines
End If

--
Wayne Morgan
MS Access MVP
"jpr" <jp***@tin.it> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

Hello,
I have a form with twa txtboxes named mytxt and txtresult.

The txtresult gets its data from a module (GetInterval).

I have written this statement:

If IsNull (Me.mytxt) then
Me.txtresult) = Null

I get an error as if that control cannot contain null values.

I have done the same with another sample, simply changing the record
source of my txtresult to a field of my table and works?

can anyone see the problem?

I have also tried in with this code but still nothing:

If Len(Trim$(Me!USER & vbNullString)) = 0 Then

Thanks.

[jpr]

Hello,
well, the record source of my control is not based on a field of a
table but on a code which recall a module.
What I need is simple something that says:

If txtresult has no data, then do not show the value in txtresult. See
the problem I am having is that since there is a date function code
that reads in the txtcontrol it will always show up even if there is no
data.
Basically my txtcontrol sums four other date controls. If these have
data then it txtresult should be visible if not it should not be
visible.

Thanks.
Wayne Morgan wrote:

How does txtResult get its data from the module? What is the Control Source
of txtResult? If txtResult is bound to a field, is the field defined in the
table as Nulls not allowed (i.e. Required = Yes)? Where is the module
located, is it in the form that has these two textboxes? What is the error
that you get?

There are two typos in the example you gave (a space after IsNull and an
extra ")"), it should be:

If IsNull(Me.mytxt) Then
Me.txtresult = Null
'other lines
End If

--
Wayne Morgan
MS Access MVP
"jpr" <jp***@tin.it> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

Hello,
I have a form with twa txtboxes named mytxt and txtresult.

The txtresult gets its data from a module (GetInterval).

I have written this statement:

If IsNull (Me.mytxt) then
Me.txtresult) = Null

I get an error as if that control cannot contain null values.

I have done the same with another sample, simply changing the record
source of my txtresult to a field of my table and works?

can anyone see the problem?

I have also tried in with this code but still nothing:

If Len(Trim$(Me!USER & vbNullString)) = 0 Then

Thanks.

[Wayne Morgan]

It would help if you would include in your message what you already have
that you want modified.

Possible Control Source:

IIf(IsNull([txtResult]), "", Your Equation)

--
Wayne Morgan
MS Access MVP
"jpr" <jp***@tin.it> wrote in message
news:11*********************@y41g2000cwy.googlegro ups.com...

Hello,
well, the record source of my control is not based on a field of a
table but on a code which recall a module.
What I need is simple something that says:

If txtresult has no data, then do not show the value in txtresult. See
the problem I am having is that since there is a date function code
that reads in the txtcontrol it will always show up even if there is no
data.
Basically my txtcontrol sums four other date controls. If these have
data then it txtresult should be visible if not it should not be
visible.