Connecting Tech Pros Worldwide Forums | Help | Site Map

display a string as it is

bunna@xtra.co.nz
Guest
 
Posts: n/a
#1: Jan 25 '06
hi

i'm having a few problems with my database. i'm trying to pass a ID
into a new form but the ID has a - in it causing vb to compute this as
a sum rather then displaying it as a string.

eg ID: 2005-5 and i keep getting 2000

how can i get access to display the string as it is and not consider it
as a formula?

here is the bit of code i am using

Dim POID As String

POID = Me.lstPOLab

where lstPOLab is a list box. thanks


bunna
Guest
 
Posts: n/a
#2: Jan 25 '06

re: display a string as it is


i don't know if this helps but i've managed to figure out that it's
inserting the value into the new form ok as the default value, but the
form is automatically considering it a sum on display. so if i open the
field properties and add " around the default value, it displays fine,
but i need to know how to automate this. any help is greatly
appreciated. thanks

Closed Thread