Hendra-
If the 7th column in your Row Source is "blank" for any row, the CLng function won't like it. Try this:
=CLng(NZ(IDItems.Column(6), 0))
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Agestha Hendra
Sent: Monday, January 30, 2012 6:10 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Field Format
Thanx John,,,
I've tried it, but why the result is #erorr ?
________________________________
Dari: John Viescas <john@viescas.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Senin, 23 Januari 2012 8:28
Judul: RE: [MS_AccessPros] Field Format
Hendra-
The Column property of a combo box or list box returns a text value, so Access
is ignoring your format specification. Try changing your Control Source to:
=CLng(IDItems.Column(6))
That will convert the text to a Long Integer number.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Sunday, January 22, 2012 2:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Field Format
Hi Everyone ...
I have an unbound textbox(txtPrice) on a Form, the record source of txtPrice is
=IDItems.Column(6), [IDItems] is a field on the same Form that has Record source
refference to a query "Q_Lookup Items" where the Column(6) is a field with
Number type (formatted to Standard), i have setted the format property of
txtPrice (on Form) to Standard and also to the Field Table source of column(6)
in Q_Lookup Items to Standard too, but why the txtPrice value doesn't looks
right formated ? example, 3000000....for that example i want it looks 3,000,000
(with commas).
Regards
Hendra
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar