Hide calculated fields in continuous forms A2K

Phil Stanton

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

Subscribe Post Reply

1977

Mike MacSween

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

Phil Stanton

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

Similar topics

Saving calculated values

by: SJH | last post by:

I have been given an older database and asked to make upgrades and what not. One interesting thing I have come across with the database is that it was at one time set up so one of the tables would...

Microsoft Access / VBA

#Error in calculated field in MDE (not MDB)

by: Allen Browne | last post by:

Subform is based on a single-table query that contains a calculated field: Amount: Round(CCur(Nz(*,0)),2) Continuous subform displays this field in a text box named Amount. As user enters new...

Microsoft Access / VBA

Hide calculated fields in continuous forms A2K

by: Phil Stanton | last post by:

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...

Microsoft Access / VBA

Singling out fields on Continuous Forms

by: Cro | last post by:

Dear Access Developers, I am developing a form with 'default view' set to "continuous forms". I am suffering with a problem I can't yet see a solution too. Each record has many fields. Two...

Microsoft Access / VBA

Forms with Calculated Fields not populating

by: tconway | last post by:

I have an Access program that displays Customer data into a form and OrderID data into a subform. The totals in the Subform are based on calculated fields, i.e. the Total Amount field Calculates...

Microsoft Access / VBA

Editable query / continuous form with aggregate fields: how?

by: S P Arif Sahari Wibowo | last post by:

Hi! I would like to make an editable continous form, where most fields will be from table A and editable, except 1-3 fields are a glimpse into table B and uneditable. Table A relate to table B...

Microsoft Access / VBA

Copy fields from one continuous form to another with a button

by: Shawn Yates | last post by:

I have a form with two subforms on it which are both continous forms. The subform on the left shows the tasks that the employee was assigned to accomplish (each as a seperate record) while the one...

Microsoft Access / VBA

Unable to retrieve long string from calculated field through recordset

by: Henrik | last post by:

The problem is (using MS Access 2003) I am unable to retrieve long strings (255 chars) from calculated fields through a recordset. The data takes the trip in three phases: 1. A custom public...

Microsoft Access / VBA

Show / Hide Form depending on data

by: OzNet | last post by:

Hi I have a main form and want to put two subforms on a tabbed control (on the same tab) Subform 1 will display data if it corresponds with the data on the main form. When this is true, subform...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server