Prefix data in a text box

[Nick T]

Hi,

I have a text box (textbox A) on a form which gets its data from another
text box (textbox B) on the form. I have done this by putting =[textboxB] in
the control source of text box A. The difference being that i want want the
data in textbox A
to start and end with an *

For example:

If TextBox B displays: 12345
Then TextBox A displays: *12345*

How do i get this to happen automatically?? So that what ever data appears
in this text box, it starts and ends with *.

Thanks

Nick

 

[KARL DEWEY]

Concatenate the prefix and sufix like this --
"*" & [YourDataSource] & "*"
You do know that the asterisk is a 'wildcars' in Access and may give you
problems.