By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Hide calculated fields in continuous forms A2K

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
Some of our members sailed with the armada, and still use roods, poles
perches and fathoms.

Tradition!!!!!!!!!

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.