I'm currently presenting certain dates as YYYY/MM because Day=01 is understood.
YYYY-MM, however, looks cleaner to my eye.
But I can't get it to work with both .Format and .InputMask. They seem to
conflict when it's time to save the field's value and an "Illegal format"
message pops.
Anybody managed to pull this off, or am I fighting nature?
--
PeteCresswell
2  1727 
(PeteCresswell) wrote: I'm currently presenting certain dates as YYYY/MM because Day=01 is understood.
YYYY-MM, however, looks cleaner to my eye.
But I can't get it to work with both .Format and .InputMask. They seem to
conflict when it's time to save the field's value and an "Illegal format"
message pops.
Anybody managed to pull this off, or am I fighting nature?
I created a table with DateField, type Date. I created a form with
DateField as a control. I put in 0000\-00;0;_ as the input mask and
yyyy-dd as the format and it seems to work OK.
I didn't put in the Input mask, just the format, and entering 2005-10
works OK too.
Usina A97
In a form, I tend to use a unbound field, then set the day = 1 to the
bound field in the before update event.
I convert back in the Form Current event for those people who like to
"scroll" through the records.
For what it's worth, I don't bother with Input Masks _ever_. If
memory serves, Allen Browne has a page on his site on the pitfalls of
using Input Masks. Certainly worth a view (or two!).
On Thu, 27 Oct 2005 12:30:01 -0700, "(PeteCresswell )" <x@y.Invalid>
wrote: I'm currently presenting certain dates as YYYY/MM because Day=01 is understood.
YYYY-MM, however, looks cleaner to my eye.
But I can't get it to work with both .Format and .InputMask. They seem to
conflict when it's time to save the field's value and an "Illegal format"
message pops.
Anybody managed to pull this off, or am I fighting nature?
--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jouke Langhout |
last post by:
Hello all!
For quite some time now, I've got the following problem:
Access won't close properly when a user closes the application. An
ACCESS process stays active and that process can only be terminated by
pressing ++ and then terminate the process.
I searched the entire internet and found out that there could be two
things wrong (both of them are mentioned in the bug list on the access
|
by: Sara |
last post by:
The problem:
Conditional formatting bold, red when field Value < date() sets the
field
background to white - always - whether condition is met or not. I
want the field unfilled and just red/bold when the date has passed.
Background:
I have 2 related fields that are only rarely active, so I manage them
in the
query for the subform: ShowBlanket: IIf(,"Blanket","") and
|
by: Matthew Wieder |
last post by:
Hi - I have a datagrid that has a black header and the rows alternate
white and gray. The problem is that until items are added to the grid,
the grid appears as a large black rectangle, which is quite ugly. The
black area is larger then it is once an item is added. How can I solve
this problem either by:
A) Having only the header black and the rest of the empty block white or
gray (preffered solution)
B) Having the color gray or white...
|
by: Nalaka |
last post by:
Hi,
I have two questions about gridViews.
1. How can I intercept the row/column values at loading to change values?
2. After I update a row (using default update functionality), how can I
re-format the updated row fields.
I have looked at gridView.rowUpdated method, but cannot figure out
how....
|
by: Thomas Beyerlein |
last post by:
I am binding dates to a textbox, the date is stored in SQL in a datetime
field. When it gets bound it turns it into a long date (Sunday, Dec. 25
2005), in SQL when viewing the table it views as a shortdate. When
inserted to SQL the datetimepicker format for the date is short. I have
not had a problem with the formatting of a date to a textbox before, but
this time I am using the CurrencyManager to navigate though several
records. This is...
| | |
by: David Veeneman |
last post by:
How does one format a date column in a GridView control? I had assumed that
the DataFormat string would do it, but MSDN only shows numeric formatting
codes. Can dates be formatted using that property, or is it done some other
way?
Thanks in advance.
--
David Veeneman
Foresight Systems
|
by: OdAwG |
last post by:
Hello Again Access GURU's,
Need some help with Conditional Formatting and datediff. What I am trying
to do is the following:
I have three text boxes with dates in them and what I want to do is change
the background color if the date in the text box get within a certain date
range.
Date Range:
|
by: Ken Wigle |
last post by:
All,
I would be very grateful for any help on this question. I have an
application in asp.net 2.0 where I dynamically create a datatable and then
bind that to a gridview. Unfortunately, the date column always shows the
date and time while I just want the short date. I have tried applying a
format string {0:d} but to no avail. I saw a lot of posts regarding the
htmlencode property but I do not know how to turn that off for a...
|
by: tarscher |
last post by:
Hi all,
A simple problem that seems hard to solve...
I have a gridview with a date row.
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("time")
%>'></asp:Label>
</ItemTemplate>
|
by: RussCRM |
last post by:
I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.
Any ideas?
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |
