472,121 Members | 1,517 Online

# Hide calculated fields in continuous forms A2K

I have a form of club members with a continuous subform on it showing boat
details.
I hold the boat length and beam (in meters) in a table. On the subform I
also calculate and show the imperial equivalent length and beam. You can
enter lengths in either the metric box when an AfterUpdate event shows the
imperial eqivalent, or converseley you can enter the lenght in feet and
inches in the imperial box and on AfterUpdate the metric equivalent is
displayed and stored in the corresponding metric box.
The appropriate imperial measurements are calculated OnCurrent of the
Subform

The problem is that the the same calculated fields are displayed on every
record on the subform + the blank new record corresponding to the current
record. Is there any way of hiding and locking the Imperial calculated
fields on all but the current record. Its a sort of conditional formating on
the current record.

TIA

Phil
Nov 12 '05 #1
2 1892
I think I've had similar problems to you and couldn't find a way round it.
Sorry.

Anyway, what are they waiting for, the Spanish Armada to come floating up
the channel again? Tell them to work in metric and save you the grief.
(pssstt, it's 2004)

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:40***********************@mercury.nildram.net ...
I have a form of club members with a continuous subform on it showing boat
details.
I hold the boat length and beam (in meters) in a table. On the subform I
also calculate and show the imperial equivalent length and beam. You can
enter lengths in either the metric box when an AfterUpdate event shows the
imperial eqivalent, or converseley you can enter the lenght in feet and
inches in the imperial box and on AfterUpdate the metric equivalent is
displayed and stored in the corresponding metric box.
The appropriate imperial measurements are calculated OnCurrent of the
Subform

The problem is that the the same calculated fields are displayed on every
record on the subform + the blank new record corresponding to the current
record. Is there any way of hiding and locking the Imperial calculated
fields on all but the current record. Its a sort of conditional formating on the current record.

TIA

Phil

Nov 12 '05 #2
Some of our members sailed with the armada, and still use roods, poles
perches and fathoms.

Phil
"Mike MacSween" <mi***********************@btinternet.com> wrote in message
news:40***********************@news.aaisp.net.uk.. .
I think I've had similar problems to you and couldn't find a way round it.
Sorry.

Anyway, what are they waiting for, the Spanish Armada to come floating up
the channel again? Tell them to work in metric and save you the grief.
(pssstt, it's 2004)

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:40***********************@mercury.nildram.net ...
I have a form of club members with a continuous subform on it showing boat details.
I hold the boat length and beam (in meters) in a table. On the subform I
also calculate and show the imperial equivalent length and beam. You can
enter lengths in either the metric box when an AfterUpdate event shows the imperial eqivalent, or converseley you can enter the lenght in feet and
inches in the imperial box and on AfterUpdate the metric equivalent is
displayed and stored in the corresponding metric box.
The appropriate imperial measurements are calculated OnCurrent of the
Subform

The problem is that the the same calculated fields are displayed on every record on the subform + the blank new record corresponding to the current record. Is there any way of hiding and locking the Imperial calculated
fields on all but the current record. Its a sort of conditional
formating on
the current record.

TIA

Phil

Nov 12 '05 #3

### This discussion thread is closed

Replies have been disabled for this discussion.