Add a text value to number field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is there anyway to add a text value to number field in forms?

I would like to add "N/A" to quantity field (number field) in an order form.

I heard there is a way to achieve this by union query or something, but I
don't know how.

Thank you.
 
If the field in the form's record source bound to your form control is a
numeric data type, It will error if you try to update the record.

What you are describing sounds like a technique for adding "All" to a combo
box.
What is it you are trying to do?
 
Hi Hana,

Not sure what you are tying to do but what about this:-

In your query create a field say PrintNo (Only to used for printing)

Do some kind of iif statement to say if true use the Number else put "N/A"
like

iif(isnumeric([Qty],[Qty],"N/A"))

Trev
 
Back
Top