[MS_AccessPros] Re: combobox red as text

 

Hi Mike,

Yes. Change the DataType of the source data from
Text to Currency.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "Chubby Mike" <the_x_mikey@...> wrote:
>
> hi all,
>
> i just learn access in about 1 week and confuse about table
>
> i have a form with below description
>
> TransactionNo (textbox)
> ItemCode (combobox)
> SellPrice (combobox,child from ItemCode)
> RealPrice (textbox)
> difference (textbox, controlsource = [RealPrice] - [SellPrice]
>
> in difference, there will be a #Type! since SellPrice red as text.
> could i make SellPrice as a number even it's type is a combobox?
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___