String from bound textbox?

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi. I have this textbox on a report that is bound to an underlying query
fetching the values to the textbox from a tablefiled (text). Another
component is needing data from this textbox as a string. If I hardcode the
textbox's controlsource like ="123456-12345" then the component copes fine
with the value in the textbox.
What I can't figure out is how I get the numbers from the query (where they
are like 123456-12345) so that the component recognizes the value in the
textbox as a string. The numbers are account numbers and they always has
that "-" in the middle of the chunk of numbers.
I tried like =""" & accountnr & """ and many other variations but without
success. Any help would be wery appreciated. Jen.
 
Have you tried setting the format of the underlying query
field? I would set it to text, I think that may work.
Hope this helps.
Fons
 
Back
Top