Continuous Forms Formatting Questions

[David]

Hi,

Two questions on Continuous Forms formatting.

Question 1. I have 3 columns of data. The 3rd column always contains unique
data. The 1st 2 columns repeat from time to time. Example:

1 1 1
1 1 2
1 1 3
1 2 1
1 2 2
2 1 1
Is there a way to only print a value if the value above it is different,
thereby, eliminating the repeating values? I would have something like this:

1 1 1
2
3
1 2 1
2
2 1 1

Question 2: I want to format values on each record of the continuous form,
based on the value of a boolean field for that record. For example, if the
field "UPDATABLE" is true, I want to make another field ENABLED for updates,
and a command button for DELETING that record, ENABLED. Otherwise, these
should be DISABLED. This "kind of works", if I click on a record where
UPDATABLE is True: Those fields appear to be UPDATABLE. However, from a
user standpoint, they don't appear visibly to be UPDATABLE, as the subsequent
record, which is UPDATABLE=FALSE, then makes those fields DISABLED.

Thanks.--
David

 

[Marshall Barton]

Two questions on Continuous Forms formatting.

Question 1. I have 3 columns of data. The 3rd column always contains unique
data. The 1st 2 columns repeat from time to time. Example:

1 1 1
1 1 2
1 1 3
1 2 1
1 2 2
2 1 1
Is there a way to only print a value if the value above it is different,
thereby, eliminating the repeating values? I would have something like this:

1 1 1
2
3
1 2 1
2
2 1 1

I think you can do that by using an expression for those two
controls:
txtfld1: IIf(fld3=1, fld1, Null)
txtfld1: IIf(fld3=1, fld2, Null)

Question 2: I want to format values on each record of the continuous form,
based on the value of a boolean field for that record. For example, if the
field "UPDATABLE" is true, I want to make another field ENABLED for updates,
and a command button for DELETING that record, ENABLED. Otherwise, these
should be DISABLED. This "kind of works", if I click on a record where
UPDATABLE is True: Those fields appear to be UPDATABLE. However, from a
user standpoint, they don't appear visibly to be UPDATABLE, as the subsequent
record, which is UPDATABLE=FALSE, then makes those fields DISABLED.

You will have to simulate the buttons with locked text
boxes. Then you can use Conditional Formatting to
enable/disable them.