Date format query

[Bob]

I have date format as dd-mmm-yy is there a possible way of entering 2
letters after the date that I can change to whatever I like i.e.: dd-mmm-yy
xx

Thanks in advance.........Bob Vance

 

[Bob]

Sure, make a new field form them. You can't put anything in that date
field other than date and time.

Sorry Joseph how would I about doing that , I just want to be able to put
some text next to the date..thanx Bob

 

[Bob]

Sorry Joseph how would I about doing that , I just want to be able to put
some text next to the date..thanx Bob

This is the code how would i change it, Thanks Bob

Private Sub cmdStableReturnDate_Click()
tbStableReturnDate.value = Format(Now(), "Short Date")
End Sub

 

[Douglas J. Steele]

Sorry Joseph how would I about doing that , I just want to be able to put
some text next to the date..thanx Bob

You can't, at least not if you're using a Date field.

As Joseph states, a Date field can only hold a date/time value. That's
because under the covers, it's an 8 byte floating point number (the integer
portion represents the date as the number of days relative to 30 Dec, 1899,
and the decimal portion represents the time as a fraction of a day).

Store the text in a separate field. While you could store both in a single
text field, that would violate database normalization principles, one of
which states a single field should only hold a single value.

 

[Van T. Dinh]

1. Where do you propose to do this?

2. If it is a TextBox Control on the Form, is the binding Field a Date
Field in a Table.

3. If on a Form, what's wrong with 2 separate TextBoxes?

While it sounds feasible, e.g. an unbound TextBox, it certainly sounds like
creating extra complications for your database, since in an unbound TextBox,
you will need to write code to manipulate data.

 

[Bob]

Yes I enter the date on a form which is for a certain horse, but I wanted to
add text with the date,I suppose a separate field would do it , shows on a
report Horse name and date. Could you tell me how I would go about adding a
text box to form and show on report...Thanks Bob

 

[Van T. Dinh]

Without knowing your Table structure, I can't advise much but in general,
you need to add a Field in the underlying Table. You can then modify the
Form's RecordSource to include then new Field if you use a Query or an SQL
String for the RecordSource. (If you use the Table as the RecordSource, the
new Field will be picked up automatically.) You can then add a new TextBox
to the Form by dragging the Field from the Field list (or dragging the
TextBox Control from the ToolBox and then bind the TextBox to the new
Field).

Most Access books would cover the about process so for more detail
instruction, look up in one of the Access books you have.