NeoPa  32,568
Recognized Expert Moderator MVP
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 5386  ADezii 8,834
Recognized Expert Expert @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,568
Recognized Expert Moderator MVP
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?
ADezii 8,834
Recognized Expert Expert @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,568
Recognized Expert Moderator MVP @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.
ADezii 8,834
Recognized Expert Expert @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,568
Recognized Expert Moderator MVP
I'm afraid that would lose the format anyway ADezii. I don't think I'd get anything beyond what I started with.
FishVal 2,653
Recognized Expert Specialist
Just a thought.
Could it be so that a PK is involved in calculation?
NeoPa 32,568
Recognized Expert Moderator MVP
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. "Decimal Number" sometimes serves to distinguish Base 10
numbers, eg "15", from Base 2 numbers, Eg "1111". At other times "Decimal
Number" serves to differentiate a number from an integer. For the rest of this
post I shall only use either...
|
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 the number has 2 decimal places.
Any help would be great.
Regards,
Brent
|
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 can't figure out why the design is so that the DataRow "alters" the
value entered.
In my application a decimal column in a row of a specific table has a
fix number of decimal places according to certain premises. The
|
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 even after I have change the Fieldsize propert to Decimal with
Scale = 2, the digits after the decimal are not seen.
For eg. If the text was 16.27. After I changed to long integer, it
|
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 starting a new one]
I'd still like to finish this rounding mess. As a startup lemma we can
take that VK is the worst programmer of all times and places: let's
move from here forward please.
The usability of any program depends on exact behavior...
|
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 places. The function accepts a compulsory first argument of type double (the number to be formatted) and a second optional argument of type integer (the number of decimal places) and returns a string object containing the formatted text. If the...
|
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 graphs which serialize to
XML. Each has some decimal properties, ex:
class Widget
{
|
by: David |
last post by:
Any ideas why this statement:
mBalanceChange = Double.Parse(strCurrentBalance,
Globalization.NumberStyles.AllowThousands Or
Globalization.NumberStyles.AllowDecimalPoint) - mBalanceDouble
would leave me with a double containing over 10 decimal places when
strCurrentBalance was a string containing a double with two decimal places
and mBalanceDouble contained only two decimal places to begin with?
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
