merge multiples fields into one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marco - 20 Dec 2007 01:12 GMT

Hello. I triyng to merge multiples fields into one but I'm not being very
sucessful.

I have in my form field A and field B and C

I want to save right into field C the concanetanet or merger of fields A and B

A=gh
B=yh
C=ghyh

I tried into the code to do this C=A&B

Regards,
Marco

Reply to this Message

Allen Browne - 20 Dec 2007 01:58 GMT

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains how to get Access to give you C *without* storing it in
a table.

If you really want to do it anyway, the acticle explains how to put your
line of code into the AfterUpdate event procedure of both text boxes (A and
B.)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello. I triyng to merge multiples fields into one but I'm not being very
> sucessful.
[quoted text clipped - 12 lines]
> Regards,
> Marco

Reply to this Message