NeoPa  32,556
Expert Mod 16PB
I have noticed this over many versions of Access and was wondering if anyone could throw any light on why this seems to happen.
It seems that when designing a QueryDef in the QBE grid and specifying the Properties of an individual numeric field, the Decimal Places property is often invisible. From observation this seems to occur when the Field: is set to a calculation of some form (rather than a simple field from one of the TableDefs). Often, though not always, the Decimal Places property will become visible after the QueryDef is actually run and figures are returned. When next the QueryDef is opened for design though, it is again invisible.
As the Format property is visible in all cases, I can see no rationale for this. Does anyone have any explanation / ideas?
8 5343  @NeoPa
The only idea that I can come up with is that the DecimalPlaces property setting has no effect whatsoever if the Format property is set to blank. For some 'crazy' reason, there may be no justification for displaying the Decimalplaces Property should the Format Value be blank. I know this is a little far fetched, but I can see no other reason/logic.
NeoPa 32,556
Expert Mod 16PB
Unfortunately ADezii, it doesn't show it even when the Format property is set, whether as something like Standard or even as "#,##0.00".
Is this something you've noticed yourself? Or am I plagued by strange poltergeist phenomena?
@NeoPa
There goes my Theory out the window! (LOL). To be honest, I have never noticed this behavior, but I do like to explicitly control the Number of Decimal Places via the Format(), FormatNumber() Functions rather then set this Property.
NeoPa 32,556
Expert Mod 16PB @ADezii
Not for me. Using Format() changes the Type of the field's value. This is not acceptable behaviour globally. It will be ok in some instances, but that cannot be guaranteed so I don't like to assume.
@NeoPa
Good point, NeoPa. I'm assuming then that you would not consider Explicit Conversion in conjunction with Format(), as in: - CSng(Format(<expression>,"0.00"))
NeoPa 32,556
Expert Mod 16PB
I'm afraid that would lose the format anyway ADezii. I don't think I'd get anything beyond what I started with.
Just a thought.
Could it be so that a PK is involved in calculation?
NeoPa 32,556
Expert Mod 16PB
No Fish. Not as far as I can see. I have it currently with a field that is not indexed at all.
Do you never experience this? Possibly you don't ever set the properties and have never noticed?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: John Bentley |
last post by:
John Bentley:
INTRO
The phrase "decimal number" within a programming context is ambiguous. It could
refer to the decimal datatype or the related but separate concept of a generic
decimal number....
|
by: Brent Bortnick |
last post by:
Does anyone know how to find out the number of decimal
places a number has. I need this info so that i can round
to 3 decimal places if the number has 3 decimal places or
to 2 decimal places if...
|
by: Carl G |
last post by:
I am storing a 0.000 a System.Decimal in a DataRow.
On retrieval the value is only 0 without the three decimal places.
It looks like the Get property returns System.Decimal.Zero, but
why????
I...
|
by: italia |
last post by:
I changed the Fieldsize Property from text to Long Integer and Decimal
Places = 6.
I had decimals in the original field. But after the transfer, the
digits after the decimals are gone.
Now...
|
by: nick |
last post by:
printf("%lf",3.25);
the result is 3.25000
i want the answer correct to 3 decimal places
What should i do?
thanks!
|
by: VK |
last post by:
http://groups.google.com/group/comp.lang.javascript/browse_frm/thread/
b495b4898808fde0>
is more than one month old - this may pose problem for posting over
some news servers. This is why I'm...
|
by: scan87 |
last post by:
Can somone please, please give me the solution for the following problem. I need to submit it on Monday.
Write a global function called format, which formats numbers with a given number of decimal...
|
by: James Koch |
last post by:
I must be missing something here...
The inconsistency described below is minorly annoying in a current
project. Can anyone come up w/ an explanation?
I've got two seemingly identical object...
|
by: David |
last post by:
Any ideas why this statement:
mBalanceChange = Double.Parse(strCurrentBalance,
Globalization.NumberStyles.AllowThousands Or
Globalization.NumberStyles.AllowDecimalPoint) - mBalanceDouble
...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
