Adding * to beginning and end of textbox text

[jre1229]

After a user tabs off of the field they were just in, I would like to add an * at the beginning and end of that text. I need the * in the front and back so that our barcode scanner will read the barcode correctly but I don't want to have to rely on someone to manually enter the * every time. Any ideas?

[Robeen]

What is the data type of the data in the field to which you want to add the two *s?
I mean - what kind of data is going to be in that field?

[jre1229]

It's numbers but I have it set to Text so that it will accept *'s

[Robeen]

You can put something like this in the 'On Lost Focus' Event of the text box.

 
Me.YourTextBoxName.Text = "*" & Me.YourTextBoxName.Text & "*"

Let me know if this works for you.

[boblarson]

You can put something like this in the 'On Lost Focus' Event of the text box.

 
Me.YourTextBoxName.Text = "*" & Me.YourTextBoxName.Text & "*"

Let me know if this works for you.

and if that doesn't work (which will probably not work because you used .TEXT which needs to have focus and so you will get an error as the lost focus means it isn't selected anymore), you most assuredly can use this:

Me.YourTextBoxName = Chr(42) & Me.YourTextBoxName & Chr(42)

[jre1229]

Great idea! I didn't use this but you did spark an idea. I actually left the data going into the database without the * then when I pull it out for a report I add the *.

[Robeen]

and if that doesn't work (which will probably not work because you used .TEXT which needs to have focus and so you will get an error as the lost focus means it isn't selected anymore), you most assuredly can use this:

Me.YourTextBoxName = Chr(42) & Me.YourTextBoxName & Chr(42)

Bob - I tested the code before I posted. It works.

[boblarson]

Bob - I tested the code before I posted. It works.

Regardless, you should not use .TEXT if at all possible. Use .Value instead unless you can't.