Search results

I have the same need for tabs in Memo fields..I have use Access 97, but not too familiar with codes.. Please explain how to use this code. Thanks in Advance.

OK! I got it!! 1. I had to set the Date/Time data type as a custom format as mmmm dd"," yyyy 2. then I have to set my Computer's Date/Time format by going under Control Panel and Regional settings, then set that LongDate style to mmmm dd, yyyy (this is one of the available options) then the...

jeff, Just a clarification: the text box control does not have a fotmat property. It has a whole tab full of properties you can set, but not the date format though. The help file emans the format property of the "date/Time" data type in the table. It works. But still, I have to click at least...

Thanks again Jeff. I will try it out and read the help pages as well.

Jeff, I am super newbie. I now see the date format, but how will i use this though? I went to the Design view of the table. Set the data type of the field as Date/Time. Then in the default value I set that to "date()" In the format i set "MyDate = Format(Date, "mmmm d, yyyy")". Now when I...

In an Access 97 (Office 97) DB, the design requires date to be in the format "January 15, 2000" but the closest Access 97 format is the "LongDate" which is "Saturday, January 15, 2000". I am using date() to automatically insert the dates when the input form opens. Can anyone suggest how I will...

Now a new one for Travis and anyone else who would like to comment: I know one can copy all the data from all fields of a record and "appendpaste" into a new record. Please see if i am going about this in the right way: Goal: User must be able to search (by clicking a button to run a query)...

Thanks Travis, Works good. Now, I could get rid of 16 reports. And making design changes could happen in just one. Thanks again. --------------------------------- Now there is a new one: Since it relates to "FORMS" I am posting it in the Forms section.

A DB in Access97 (Office97)has several reports. They all have the same data from the same table, and same format. But, each report derives the data from corresponding queries. Origianlly I made several reprots by copying the first one and changed the "DataSource" and "Caption" properties...