Textbox contents

[Peter]

Hello everyone,

I have trouble grasping the possibilities of the controls that you can put
onto a form.

In this case I want to fill a textbox on a form with information that is
stored in several separate fields from one particular table.

This is the concrete info:
Table name: Object data
Relevant fields:
Objectnumber : Primary key; 5 digit number (lowest possible number being
10000)
Client name
Address
Zip Code
City

These are, as said, separate fields. What I want to do is make a form to be
used to edit another or maybe more tables, linked by the primary key field
which is the objectnumber. To confirm the identity of the client to the
user, I want to place a textbox on the form that summarizes the name and
address data of the client.
I have no idea how to do this. In excel this is a breeze for me, in Access I
can look at the screen for times on end, get distracted and therefore
nowhere.
Please help.

Greetings,
Peter

 

[ruralguy via AccessMonster.com]

Start by letting the Form Wizard create a form for you. The add an Unbound
TextBox and set the Control Source to:
=Me.Control1 & " " & Me.Control2 etc.
...using your control names of course.
Use & vbCrLf & if you want the data on a new line.

 

[Peter]

Thank you, RG. Can you tell me where to put this exactly. It's obviously vba
code so I assume I need to add a module. In MS Acces working with vba is
very difficult for me.

Thank you.
Peter

 

[ruralguy via AccessMonster.com]

Just put it directly in the ControlSource of the Unbound Control.

Thank you, RG. Can you tell me where to put this exactly. It's obviously vba
code so I assume I need to add a module. In MS Acces working with vba is
very difficult for me.

Thank you.
Peter

Start by letting the Form Wizard create a form for you. The add an
Unbound

[quoted text clipped - 36 lines]

 

[Peter]

Thank you again, RG.
I got the textbox to show the individual parts consecutively. The & vb CrLf
& part however, leads to an error message along the lines of #Name? (I use
the dutch version (#Naam?), so I hope that I chose the correct translation
for this error message and that the translation means something to you).
Acces seems to put this part between angled brackets [] all by itself when
going back into the expression to evaluate it.
I tried something that always works in excel which is using chr(10) instead
vbCrLf, but that too resulted in error. I don't know how to proceed and you
have given me the techniques to use, so I've exhausted your knowledge on
this issue. I thank you again for your help.

Peter

Just put it directly in the ControlSource of the Unbound Control.

Thank you, RG. Can you tell me where to put this exactly. It's obviously
vba
code so I assume I need to add a module. In MS Acces working with vba is
very difficult for me.

Thank you.
Peter

Start by letting the Form Wizard create a form for you. The add an
Unbound

[quoted text clipped - 36 lines]

Greetings,
Peter

 

[ruralguy via AccessMonster.com]

Try using a query for you form instead of a table and create another field
with your concantenated data that includes vbCrLf of Chr(13) & Chr(10) and
see what happens.

Thank you again, RG.
I got the textbox to show the individual parts consecutively. The & vb CrLf
& part however, leads to an error message along the lines of #Name? (I use
the dutch version (#Naam?), so I hope that I chose the correct translation
for this error message and that the translation means something to you).
Acces seems to put this part between angled brackets [] all by itself when
going back into the expression to evaluate it.
I tried something that always works in excel which is using chr(10) instead
vbCrLf, but that too resulted in error. I don't know how to proceed and you
have given me the techniques to use, so I've exhausted your knowledge on
this issue. I thank you again for your help.

Peter

Just put it directly in the ControlSource of the Unbound Control.

[quoted text clipped - 11 lines]