no date.... move upwards

[Jean-Paul]

Hi
In the report details I wrote:

If IsNull(Me!Nieuw_gegeven) = True Then
Me!oud_gegeven.Top = "0,6cm"
End If

This doesn't seem to work...
How can I move the following line upwards when data is empty.

Thanks

 

[Jeff Boyce]

Jean-Paul

You are asking a "how" question.

"Why?" As in "why do you want to do this?"

It may be that you can use the CanGrow and CanShrink properties of the
controls to accommodate records without certain data...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jean-Paul]

sorry having confused you..
The idea is the following:

line1 shoudl display me!Nieuw_gegeven
line2 me!oud_gegeven

What I want is, when me!Nieuw_gegeven is empty, it should not be printed
and the data of line 2 should move a few cm up, just there where line1
would be printed if it wasn't empty....
Now the top property of line 1 is 0,6cm
line 2 has top: 1,099 cm

If data of line1 is empty, line 2 should get top 0,6cm instead of 1,099cm

See???
(pffff dutch is much easier to explainsituations.....)

 

[Jeff Boyce]

Jean-Paul

Please review my previous post.

Open the report in design view, open the properties window for
[Niew-gegeven] and look at CanGrow and CanShrink.

Set them to "Yes".

Try now...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jean-Paul]

which I did....
It works when I have just an entryfield, without the "leading" text.
I deleted this text and indeed cangrow/shrink works but, when I write:

="from who is this information?" & [Nieuw_gegeven]

In the entryfield property, I get an error.

What is wrong with this syntax?

Thanks

Jean-Paul

Please review my previous post.

Open the report in design view, open the properties window for
[Niew-gegeven] and look at CanGrow and CanShrink.

Set them to "Yes".

Try now...

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry having confused you..
The idea is the following:

line1 shoudl display me!Nieuw_gegeven
line2 me!oud_gegeven

What I want is, when me!Nieuw_gegeven is empty, it should not be printed
and the data of line 2 should move a few cm up, just there where line1
would be printed if it wasn't empty....
Now the top property of line 1 is 0,6cm
line 2 has top: 1,099 cm

If data of line1 is empty, line 2 should get top 0,6cm instead of 1,099cm

See???
(pffff dutch is much easier to explainsituations.....)

 

[Jeff Boyce]

Jean-Paul

So you're saying that you want to see NOTHING for that control (not even the
"from whom is this information?") when there's nothing in the [Niew_gegeven]
field?

One approach might be to put that text in the label rather than the text
control. Then using CanGrow/CanShrink will "hide" the control and its
associated label if there's nothing in it. NOTE: "Null" is NOT the same as
"" (zero-length string). The CanGrow/... works only with Null.

Regards

Jeff Boyce
Microsoft Office/Access MVP

which I did....
It works when I have just an entryfield, without the "leading" text.
I deleted this text and indeed cangrow/shrink works but, when I write:

="from who is this information?" & [Nieuw_gegeven]

In the entryfield property, I get an error.

What is wrong with this syntax?

Thanks

Jean-Paul

Please review my previous post.

Open the report in design view, open the properties window for
[Niew-gegeven] and look at CanGrow and CanShrink.

Set them to "Yes".

Try now...

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry having confused you..
The idea is the following:

line1 shoudl display me!Nieuw_gegeven
line2 me!oud_gegeven

What I want is, when me!Nieuw_gegeven is empty, it should not be printed
and the data of line 2 should move a few cm up, just there where line1
would be printed if it wasn't empty....
Now the top property of line 1 is 0,6cm
line 2 has top: 1,099 cm

If data of line1 is empty, line 2 should get top 0,6cm instead of
1,099cm

See???
(pffff dutch is much easier to explainsituations.....)

Jeff Boyce wrote:
Jean-Paul

You are asking a "how" question.

"Why?" As in "why do you want to do this?"

It may be that you can use the CanGrow and CanShrink properties of the
controls to accommodate records without certain data...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi
In the report details I wrote:

If IsNull(Me!Nieuw_gegeven) = True Then
Me!oud_gegeven.Top = "0,6cm"
End If

This doesn't seem to work...
How can I move the following line upwards when data is empty.

Thanks

 

[Jean-Paul]

Hey Jeff...

I think this is what I tried by writing:
="from whom is this information?" & [Nieuw_gegeven]
But then I get an error (#error)

What do I do wrong or
What would be another approach?

Thans again.
JP (getting depressed)

Jean-Paul

So you're saying that you want to see NOTHING for that control (not even the
"from whom is this information?") when there's nothing in the [Niew_gegeven]
field?

One approach might be to put that text in the label rather than the text
control. Then using CanGrow/CanShrink will "hide" the control and its
associated label if there's nothing in it. NOTE: "Null" is NOT the same as
"" (zero-length string). The CanGrow/... works only with Null.

Regards

Jeff Boyce
Microsoft Office/Access MVP

which I did....
It works when I have just an entryfield, without the "leading" text.
I deleted this text and indeed cangrow/shrink works but, when I write:

="from who is this information?" & [Nieuw_gegeven]

In the entryfield property, I get an error.

What is wrong with this syntax?

Thanks

Jean-Paul

Please review my previous post.

Open the report in design view, open the properties window for
[Niew-gegeven] and look at CanGrow and CanShrink.

Set them to "Yes".

Try now...

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry having confused you..
The idea is the following:

line1 shoudl display me!Nieuw_gegeven
line2 me!oud_gegeven

What I want is, when me!Nieuw_gegeven is empty, it should not be printed
and the data of line 2 should move a few cm up, just there where line1
would be printed if it wasn't empty....
Now the top property of line 1 is 0,6cm
line 2 has top: 1,099 cm

If data of line1 is empty, line 2 should get top 0,6cm instead of
1,099cm

See???
(pffff dutch is much easier to explainsituations.....)

Jeff Boyce wrote:
Jean-Paul

You are asking a "how" question.

"Why?" As in "why do you want to do this?"

It may be that you can use the CanGrow and CanShrink properties of the
controls to accommodate records without certain data...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi
In the report details I wrote:

If IsNull(Me!Nieuw_gegeven) = True Then
Me!oud_gegeven.Top = "0,6cm"
End If

This doesn't seem to work...
How can I move the following line upwards when data is empty.

Thanks

 

[Jeff Boyce]

As my previous response mentioned, put the text into the label control
associated with the textbox control. Then set the CanGrow/CanShrink
properties of the textbox control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hey Jeff...

I think this is what I tried by writing:
="from whom is this information?" & [Nieuw_gegeven]
But then I get an error (#error)

What do I do wrong or
What would be another approach?

Thans again.
JP (getting depressed)

Jean-Paul

So you're saying that you want to see NOTHING for that control (not even
the "from whom is this information?") when there's nothing in the
[Niew_gegeven] field?

One approach might be to put that text in the label rather than the text
control. Then using CanGrow/CanShrink will "hide" the control and its
associated label if there's nothing in it. NOTE: "Null" is NOT the same
as "" (zero-length string). The CanGrow/... works only with Null.

Regards

Jeff Boyce
Microsoft Office/Access MVP

which I did....
It works when I have just an entryfield, without the "leading" text.
I deleted this text and indeed cangrow/shrink works but, when I write:

="from who is this information?" & [Nieuw_gegeven]

In the entryfield property, I get an error.

What is wrong with this syntax?

Thanks

Jeff Boyce wrote:
Jean-Paul

Please review my previous post.

Open the report in design view, open the properties window for
[Niew-gegeven] and look at CanGrow and CanShrink.

Set them to "Yes".

Try now...

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry having confused you..
The idea is the following:

line1 shoudl display me!Nieuw_gegeven
line2 me!oud_gegeven

What I want is, when me!Nieuw_gegeven is empty, it should not be
printed and the data of line 2 should move a few cm up, just there
where line1 would be printed if it wasn't empty....
Now the top property of line 1 is 0,6cm
line 2 has top: 1,099 cm

If data of line1 is empty, line 2 should get top 0,6cm instead of
1,099cm

See???
(pffff dutch is much easier to explainsituations.....)

Jeff Boyce wrote:
Jean-Paul

You are asking a "how" question.

"Why?" As in "why do you want to do this?"

It may be that you can use the CanGrow and CanShrink properties of
the controls to accommodate records without certain data...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi
In the report details I wrote:

If IsNull(Me!Nieuw_gegeven) = True Then
Me!oud_gegeven.Top = "0,6cm"
End If

This doesn't seem to work...
How can I move the following line upwards when data is empty.

Thanks

 

[Jean-Paul]

Jeff:

this is what I did
On the foem I created a textbox (ab with a vertical line)
Placed it on the report
Here I see:
first: text 23 (I think you call that a label)
then a rectangle with something like "not depending" (I translate it
from my Dutch version)

In this (second part) I open the property, pick the second tab, first
item and choose "nieuw-gegeven"
then, first tab, CanGrow/CanShrink

When there is data the field is shown..
When there isn't only the lable is shown....

Again: this is something I don't want... no data, no label, move
following line one position up....

When I remove the label and enter ="from whom is this information?" &
[Nieuw_gegeven] (in the first item of the second tab) I get an #error

This seems so basic but so complicated to explain...

Sorry Jeff and thanks for your patience

JP, Belgium

As my previous response mentioned, put the text into the label control
associated with the textbox control. Then set the CanGrow/CanShrink
properties of the textbox control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hey Jeff...

I think this is what I tried by writing:
="from whom is this information?" & [Nieuw_gegeven]
But then I get an error (#error)

What do I do wrong or
What would be another approach?

Thans again.
JP (getting depressed)

Jean-Paul

So you're saying that you want to see NOTHING for that control (not even
the "from whom is this information?") when there's nothing in the
[Niew_gegeven] field?

One approach might be to put that text in the label rather than the text
control. Then using CanGrow/CanShrink will "hide" the control and its
associated label if there's nothing in it. NOTE: "Null" is NOT the same
as "" (zero-length string). The CanGrow/... works only with Null.

Regards

Jeff Boyce
Microsoft Office/Access MVP

which I did....
It works when I have just an entryfield, without the "leading" text.
I deleted this text and indeed cangrow/shrink works but, when I write:

="from who is this information?" & [Nieuw_gegeven]

In the entryfield property, I get an error.

What is wrong with this syntax?

Thanks

Jeff Boyce wrote:
Jean-Paul

Please review my previous post.

Open the report in design view, open the properties window for
[Niew-gegeven] and look at CanGrow and CanShrink.

Set them to "Yes".

Try now...

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry having confused you..
The idea is the following:

line1 shoudl display me!Nieuw_gegeven
line2 me!oud_gegeven

What I want is, when me!Nieuw_gegeven is empty, it should not be
printed and the data of line 2 should move a few cm up, just there
where line1 would be printed if it wasn't empty....
Now the top property of line 1 is 0,6cm
line 2 has top: 1,099 cm

If data of line1 is empty, line 2 should get top 0,6cm instead of
1,099cm

See???
(pffff dutch is much easier to explainsituations.....)

Jeff Boyce wrote:
Jean-Paul

You are asking a "how" question.

"Why?" As in "why do you want to do this?"

It may be that you can use the CanGrow and CanShrink properties of
the controls to accommodate records without certain data...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi
In the report details I wrote:

If IsNull(Me!Nieuw_gegeven) = True Then
Me!oud_gegeven.Top = "0,6cm"
End If

This doesn't seem to work...
How can I move the following line upwards when data is empty.

Thanks

 

[Jeff Boyce]

Jean-Paul

Based on your description, I'm guessing the "label control" you are using is
NOT connected to the textbox control.

Try this ... 'cut' (Ctrl-X) the label control, highlight the textbox
control, and 'paste' (Ctrl-V) the label control onto the textbox control.

Now try the CanGrow/Shrink...

By the way, if there are any other controls lined up horizontally with the
textbox, it won't shrink...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff:

this is what I did
On the foem I created a textbox (ab with a vertical line)
Placed it on the report
Here I see:
first: text 23 (I think you call that a label)
then a rectangle with something like "not depending" (I translate it from
my Dutch version)

In this (second part) I open the property, pick the second tab, first item
and choose "nieuw-gegeven"
then, first tab, CanGrow/CanShrink

When there is data the field is shown..
When there isn't only the lable is shown....

Again: this is something I don't want... no data, no label, move following
line one position up....

When I remove the label and enter ="from whom is this information?" &
[Nieuw_gegeven] (in the first item of the second tab) I get an #error

This seems so basic but so complicated to explain...

Sorry Jeff and thanks for your patience

JP, Belgium

As my previous response mentioned, put the text into the label control
associated with the textbox control. Then set the CanGrow/CanShrink
properties of the textbox control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hey Jeff...

I think this is what I tried by writing:
="from whom is this information?" & [Nieuw_gegeven]
But then I get an error (#error)

What do I do wrong or
What would be another approach?

Thans again.
JP (getting depressed)



Jeff Boyce wrote:
Jean-Paul

So you're saying that you want to see NOTHING for that control (not
even the "from whom is this information?") when there's nothing in the
[Niew_gegeven] field?

One approach might be to put that text in the label rather than the
text control. Then using CanGrow/CanShrink will "hide" the control and
its associated label if there's nothing in it. NOTE: "Null" is NOT
the same as "" (zero-length string). The CanGrow/... works only with
Null.

Regards

Jeff Boyce
Microsoft Office/Access MVP

which I did....
It works when I have just an entryfield, without the "leading" text.
I deleted this text and indeed cangrow/shrink works but, when I write:

="from who is this information?" & [Nieuw_gegeven]

In the entryfield property, I get an error.

What is wrong with this syntax?

Thanks

Jeff Boyce wrote:
Jean-Paul

Please review my previous post.

Open the report in design view, open the properties window for
[Niew-gegeven] and look at CanGrow and CanShrink.

Set them to "Yes".

Try now...

Regards

Jeff Boyce
Microsoft Office/Access MVP

sorry having confused you..
The idea is the following:

line1 shoudl display me!Nieuw_gegeven
line2 me!oud_gegeven

What I want is, when me!Nieuw_gegeven is empty, it should not be
printed and the data of line 2 should move a few cm up, just there
where line1 would be printed if it wasn't empty....
Now the top property of line 1 is 0,6cm
line 2 has top: 1,099 cm

If data of line1 is empty, line 2 should get top 0,6cm instead of
1,099cm

See???
(pffff dutch is much easier to explainsituations.....)

Jeff Boyce wrote:
Jean-Paul

You are asking a "how" question.

"Why?" As in "why do you want to do this?"

It may be that you can use the CanGrow and CanShrink properties of
the controls to accommodate records without certain data...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi
In the report details I wrote:

If IsNull(Me!Nieuw_gegeven) = True Then
Me!oud_gegeven.Top = "0,6cm"
End If

This doesn't seem to work...
How can I move the following line upwards when data is empty.

Thanks