Re: [MS_AccessPros] Re: combobox red as text

 

It works, OMG, it's so simple. Thanks
Sent from my BlackBerry yg belum lunas

-----Original Message-----
From: "Clive" <zctek@aol.com>
Sender: MS_Access_Professionals@yahoogroups.com
Date: Tue, 06 Mar 2012 11:27:32
To: <MS_Access_Professionals@yahoogroups.com>
Reply-To: MS_Access_Professionals@yahoogroups.com
Subject: [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?
>




[Non-text portions of this message have been removed]

__._,_.___

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

Messages in this topic (3)

Recent Activity:

• New Members 5

Visit Your Group

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

.

__,_._,___