Mergin "free text" and "field value" in a text field?

[Mikael Lindqvist]

Hi,

I wonder if it's possible to include some text in a text field.

For example:

Name: Bart Simpson

(Where Bart Simpson is the text field value)

I would like to change this so it looks like:

Name: / Bart Simpson

Is it doable?

Kindly,
Mikael
Sweden

 

[Allen Browne]

If the field name is ClientName, you can do this on a report by setting the
ControlSource of the text box to:
="Name:/ " & [ClientName]

There are a couple of traps though:

a) The Name property of the text box cannot be the same as a field name.

b) Don't use a field called name. Access will get confused and think that
Name means the name of the report rather than the contents of the field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...