How to trim from "text box" data after enter.

[veiko]

I have lately strugling seemingly with simple thing how to trim from "text box" data after enter. Shortly, user enter data with barcode scanner(we can't trim barcode scanner) and after enter data textbox must cut automatically some data from end (or beginning) 6 characters. After that access automatically finding from database right data and shows it(but data what i want to search is not same between database and entered data to textbox and because i must trim after entering data from textbox). Can anybody help me we seemingly simple thing, i've looking from google but can't find anything about it.

[June7]

Use string functions to manipulate string data: Left, Right, Mid, InStr, InStrRev, Len.

I don't really understand all you describe. What exactly do you need to trim? Show example data.

[veiko]

Use string functions to manipulate string data: Left, Right, Mid, InStr, InStrRev, Len.

I don't really understand all you describe. What exactly do you need to trim? Show example data.

Sorry, english is not my homelanguage and i try to explain again .
On the Form is textbox, behind this textbox is vba code what search from database and which shows automatically result under this textbox.
User entering data with barcode scanner (we can't configure barcode scanner to trim data) example1 "abcdefghi.12345687890" but in database is different data example2 "abcdefghi.1234zxcvbn"(different last 6 characters). You can notice that is difference between 2 example data, from second example is different 6 character when first exmaple, by the way this data is same and i can't search from entered data (example1) before when i at first delete last characters, because it is different from database(example2). Now i must somehow cut or trim last 6 character automatically from textbox after it entered with barcode scanner before it can search and show result from database.
I understand how to trim in database, but in database must stay same value and i can't change it. Only option is it change "textbox" value(delete last 6 characters) before it will searching data, but i don't know how to do it!

[June7]

Use the functions I listed. Search Access Help or web to learn more about string manipulation.

Left(Me.textboxname, Len(Me.textboxname)-6)

[orange]

You could review the SelStart and SelLength properties of textbox and see if these are relevant.

Often, instead of trying to explain in language, a simple example will show the input and desired output.
A picture may be worth 1000 words.

[Missinglinq]

...Only option is it change "textbox" value(delete last 6 characters) before it will searching data...

Much of your explanation is still not clear, but if the above statement is the core of what you're trying to accomplish, June7's example

Left(Me.textboxname, Len(Me.textboxname)-6)

will do the job once you replace textboxname with the actual name of your Textbox.

Linq ;0)>

[veiko]

now i made at first new button to test this and put in this button code "Left(Me.txtSearch, Len(Me.txtSearch)-6)" - textbox name is "textSearch" but it gives compile error, you can see this error on attached picture. What went wrong?

[June7]

Have to use the expression to set the value of something - in textbox ControlSource, in VBA to set variable, or use it in a query to create a calculated field. Examples:

=Left(fieldname, Len(fieldname)-6)

Me.textboxname = Left(Me.textboxname, Len(Me.textboxname)-6)

Dim strUPC As String
strUPC = Left(Me.textboxname, Len(Me.textboxname)-6)

SELECT *, Left(fieldname, Len(fieldname)-6) AS ShortUPC FROM tablename;