Barcode Identifier

Hello everyone,
Your assistance on this will be appreciated

I created a simple form in access to scan barcode item information.
For example, there is a label is barcoded using an identifier such as
Purchase order with identifier "1K" in front of the number ex.
1K123454 and barcode item startswith "P" for example
"P00-104445-000A". I would like it when I scan Item for example to go
to item text box automatically by regcognizing "P" as item.
I know it can be done and I tried the following and it does not work:

If mytextbox.text.toupper.startwith ("1K") then
mytextbox.text = mytextbox.text.replace("1K","")
end if

I know this is in VB.net and toupper and startwith in access does not
work

any suggestion, please

Thank you

majic

On Sat, 29 Aug 2009 07:56:23 -0700 (PDT), Majic <fazamoineau DeleteThis @aol.com>
wrote:

The equivalent expression would be:
if left(ucase(mytextbox.text),2) = "1K" then
mytextbox.text = Mid(mytextbox.text,3)
end if

Note that the text property is only available if the textbox has
focus. Otherwise use the value property.

-Tom.
Microsoft Access MVP




>Hello everyone,
>Your assistance on this will be appreciated
>
>I created a simple form in access to scan barcode item information.
>For example, there is a label is barcoded using an identifier such as
>Purchase order with identifier "1K" in front of the number ex.
>1K123454 and barcode item startswith "P" for example
>"P00-104445-000A". I would like it when I scan Item for example to go
>to item text box automatically by regcognizing "P" as item.
>I know it can be done and I tried the following and it does not work:
>
>If mytextbox.text.toupper.startwith ("1K") then
> mytextbox.text = mytextbox.text.replace("1K","")
>end if
>
>I know this is in VB.net and toupper and startwith in access does not
>work
>
>any suggestion, please
>
>Thank you
>
>majic