Add a text value to number field

[hana]

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.

 

[Klatuu]

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?

 

[Trever B]

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