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

Help needed with metric conversion fields

P: n/a
Hi,

I need some help coding for the following:

I would like to have two blank fields in an Access form

FldPounds
FldKilograms

I would like the user to be able to enter a value in either field and have
the other field automatically fill in.

By the way, Lbs * 2.2 = Kg or Kg / 2.2 = Lbs

Thanks for the help

Tim
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Put the following code in the AfterUpdate event of FldPounds:
Me!FldKilograms = Me!FldPounds*2.2

Put the following code in the AfterUpdate event of FldKilograms:
Me!FldPounds = Me!FldKilograms/2.2

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Tim Graichen" <Tg*******@neo.rr.com> wrote in message
news:4_*******************@fe2.columbus.rr.com...
Hi,

I need some help coding for the following:

I would like to have two blank fields in an Access form

FldPounds
FldKilograms

I would like the user to be able to enter a value in either field and have
the other field automatically fill in.

By the way, Lbs * 2.2 = Kg or Kg / 2.2 = Lbs

Thanks for the help

Tim

Nov 13 '05 #2

P: n/a
Take a closer look :-)
By the way, Lbs * 2.2 = Kg or Kg / 2.2 = Lbs

Pardon? I think you have those backwards... 1kg = 2.2lbs

Or do you really want to claim that I weigh 396kg! <G>

--
================================================== ============ <
wl*****@ix.netcom.com | Wulfraed Dennis Lee Bieber KD6MOG <
wu******@dm.net | Bestiaria Support Staff <
================================================== ============ <
Home Page: <http://www.dm.net/~wulfraed/> <
Overflow Page: <http://wlfraed.home.netcom.com/> <

Nov 13 '05 #3

P: n/a
On Thu, 28 Oct 2004 02:31:23 -0400, "Konstantinos" <no*****@noemail.net> wrote:
Take a closer look :-)
He is Correct

kg * 2.2 = lbs
lbs / 2.2 = kg

2kg * 2.2 = 4.4lbs
4.4lbs / 2.2 = 2kg
By the way, Lbs * 2.2 = Kg or Kg / 2.2 = Lbs

Pardon? I think you have those backwards... 1kg = 2.2lbs

Or do you really want to claim that I weigh 396kg! <G>

--
> ================================================== ============ <
> wl*****@ix.netcom.com | Wulfraed Dennis Lee Bieber KD6MOG <
> wu******@dm.net | Bestiaria Support Staff <
> ================================================== ============ <
> Home Page: <http://www.dm.net/~wulfraed/> <
> Overflow Page: <http://wlfraed.home.netcom.com/> <


Wayne Gillespie
Gosford NSW Australia
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.