Re: Format issue ... 2 decimal places displayed?

Jeanette,

I learned something! ... here is the SQL View:

SELECT tblNewReten.RECNO, tblNewReten.HA, tblNewReten.POLYR, tblNewReten.PROPRET, tblNewReten.LIABRET, tblNewReten.LIABAGG, tblNewReten.PROPAGG, tblNewReten.MHAPDED, tblNewReten.MEMDED, tblNewReten.AUTOPHYDED, tblNewReten.TFDED, tblNewReten.EPLDED
FROM tblNewReten, tblHousingNames;


Jeanette Cunningham wrote:
Bob,
to get sql of your query, open the query in design view, then select Query | SQL view from the menu.
Copy and paste the sql into a post here.

Jeanette Cunningham

"BobC" <Bob.NoSpamm@xxxxxxx> wrote in message news:niavj.405$XO4.67@xxxxxxxxxxxxxxx
Jeanette,

It's getting rather late and I have to work tomorrow ... It may be tomorrow evening before I can get back?
In any case ... Thanks for your time and efforts!

Bob

Jeanette Cunningham wrote:
Bob,
I assume that you understand what we are trying to say. The fact that after
you make a selection in the combo it is formatted correctly suggests that
you applied the format to the combo box.
Would you post the sql of the row source query, how many columns the combo
has and the bound column.
I haven't found that using a distinct query causes problems like that.

Jeanette Cunningham

"BobC" <Bob.NoSpamm@xxxxxxx> wrote in message
news:gp9vj.402$XO4.338@xxxxxxxxxxxxxxx
Jeanette,

Maybe I am incorrectly stating the problem or am misunderstanding what you
folks are trying to get across to me?
But, I believe I have done what both you and Allen have suggested. I am
thinking that the portions of the combo box properties that you are
referring to applies to the text box portion of the combo box and does not
affect the momentary displayed list of the row source during the selection
process.

I will use one of the unbound combo boxes as an example ...

The original source of the data is a field of a table containing years
(2001, 2003, 2007, 2001, etc.). Since the years are not unique; I am
using a unique query as my row source to the combo boxes.

The problem is that while I am in the process of selecting (i.e. holding
down the drop down arrow on the right side of the combo box to select from
the row source); in this example, a specific year from a list of years;
the year will display as e.g 2008.00 as one of the choices ... until I
release the cursor and the 2008 ('without decimals') shows up in the text
box portion of the combo box. The display of years with 2 decimal places
seems undesirable, and thus the basis of my issue.

I have a hunch that the output of the unique query may have something to
do with this issue, but a display of the unique query output does not show
and decimal points in the years.

Sorry to be a pain on something that is possibly due to my
misunderstanding of what you are trying to convey?

Bob

Jeanette Cunningham wrote:
Bob,
to format the combo,
select the combo, on the property dialog, format tab, the first property
is format - this is where you set the format, you can use Allen's example
of format fixed, choose fixed in the format drop down. On the next line,
choose 0 for decimal places. Save the changes to your form.

Jeanette Cunningham

"BobC" <Bob.NoSpamm@xxxxxxx> wrote in message
news:ib8vj.4235$f8.1391@xxxxxxxxxxxxxxx
After I select a row source, the number in the text box does not display
any decimal places ... it is while I have my cursor on the tear drop to
select from the drop-down choices that it is displaying two decimal
places. Since one of the combo boxes is selecting from a choice of
'years' such as 2008; the drop down choices list '2008.00', it is
distracting.

Allen Browne wrote:
Set these properties for your text box:
Format Fixed
Decimal Places 0


.

Relevant Pages

  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • Re: Format issue ... 2 decimal places displayed?
    ... Jeanette Cunningham wrote: ... I've finally been able to reproduce that format with 2 decimal places in a combo on the form. ... to get sql of your query, open the query in design view, then select Query | SQL view from the menu. ... release the cursor and the 2008 ('without decimals') shows up in the text ...
    (microsoft.public.access.forms)
  • Re: mySQL Problem
    ... And when the query gets executed i get back the following error: ... Actually, problem is proper quoting, not the format or anything else. ... the SQL standard and won't work on any other RDBMS I'm familiar with. ... you admit that mssql uses something DIFFERENT and PARTICULAR to alias? ...
    (comp.lang.php)
  • Re: VBA ADO SQL Query Problem
    ... For long queries on a Oracle DB, I often meke it easy by using Business ... Object where I copy the SQL statement from. ... query parameter in the Oracle date format. ... But the query DID work, only no records were retrieved ...
    (microsoft.public.excel.programming)
  • Re: Format issue ... 2 decimal places displayed?
    ... I just never use Fixed format for an integer or long integer. ... Jeanette Cunningham wrote: ... to get sql of your query, open the query in design view, then select ... release the cursor and the 2008 ('without decimals') shows up in ...
    (microsoft.public.access.forms)
Loading