Form Textbox Suffix (1 Viewer)
- Thread starter cosmarchy
- Start date
Yes, this is exactly what I'm referring to
For instance, I could enter any number and it will add "kg" to the end ie I enter 123 and the textbox will display 123kg. But when I use the value of this textbox in a calculation, its value is 123.
In comparison, I can add a number number format of '0.00"kg"' to a cell and enter 123 and the cell will display 123kg...
missinglinq
AWF VIP
- Local time
- Today, 04:01
- Joined
- Jun 20, 2003
- Messages
- 6,423
Or even simpler..you can add a small Label to the right of the Textbox that says "kg."
It has the added advantage of reminding the user of the unit of measure that is to be entered.
Linq ;0)>
It has the added advantage of reminding the user of the unit of measure that is to be entered.
Linq ;0)>
If the control is bound, it cannot be a calculated control, no? (and that includes concatenation) I'm surprised no one asked (or did I miss it?)
You would have to extract the numeric portion because the true value or text of the control is 123 Kg, not 123.
IMHO, the whole idea goes against the most basic fundamentals of normalization IF the intent is to store the contents in a table as 123 Kg ; at least if the numeric part is ever meant to be used or stand alone.
isladogs
MVP / VIP
- Local time
- Today, 09:01
- Joined
- Jan 14, 2017
- Messages
- 18,207
Whilst I would also use a unit label as Linq suggested, formatting the form control as in my reply does not affect what is stored in the underlying field.
So when 12.50 kg is displayed, the stored value is 12.5 and can be used in a calculation without any additional work. For example:
So when 12.50 kg is displayed, the stored value is 12.5 and can be used in a calculation without any additional work. For example:
Attachments
-
Capture.PNG
Last edited:
- Local time
- Today, 09:01
- Joined
- Feb 19, 2013
- Messages
- 16,601
you format form controls in the same way you do in excel - using the control format property option as colin suggests (rather than in excel where format property option is in the ribbon). There are some differences between the options available
AccessBlaster
Registered User.
- Local time
- Today, 01:01
- Joined
- May 22, 2010
- Messages
- 5,911
I would concatenate them together to visually represent something new, and not save the contrived new value.
- Local time
- Today, 09:01
- Joined
- Feb 19, 2013
- Messages
- 16,601
one of the things you can do with access formatting which cannot be done in excel (so far as I am aware) is format for null and display some text
for strings it is
@;"Enter something here"
for numbers (depending on number format required for positive, negative, zero aka excel)
#;#;#;"Enter something here"
for strings it is
@;"Enter something here"
for numbers (depending on number format required for positive, negative, zero aka excel)
#;#;#;"Enter something here"
isladogs
MVP / VIP
- Local time
- Today, 09:01
- Joined
- Jan 14, 2017
- Messages
- 18,207
Formatting is being used to represent value and units. There is no contrived new value as the data is unchanged
June7
AWF VIP
- Local time
- Today, 00:01
- Joined
- Mar 9, 2014
- Messages
- 5,463
Don't confuse Format property setting with Format and FormatNumber functions. Format property does not change the stored value whereas a value modified with function is no longer the stored value. The functions return a string.
