Search results for query: *

Disregard last post. I figured out how to make it stay. Thanks to all for the assistance.

OK. So I'm beginning to understand the use of the format. I have run into one last problem with it. Using that format in the same two locations that I mentioned for auto updating earlier(obviously replacing the standard format with one from this forum) now the date appears in the text box but...

I'm not sure how to do that, which is why I'm here.

I think its currently Date. Should it be Date or otherwise for Julian?

What is the data type of the field storing that value? I'm not quite sure what you're asking. I'm not very knowledgeable in the "language" surrounding access, so I need a little extra info on what to look for. Do you mean how the form information is going to be stored? Thanks

Yes it required that and the same under the Before Update setting. But It wouldn't work with only one of those, had to do both, not sure why. But that explains why I couldn't find it. Two settings had to match. After reading your post I went looking in that direction. Thanks for the lead.

BTW found the auto update setting. >Select text box >Properties >Data Tab >Default Value "..." >Under Expression Elements: Functions: Built-In Functions >Under Expression Categories: Date/Time >Under Expression Values: Date$ Repeat process on Event Tab: Before Update "..." So... First problem...

No not at all. I just need the Julian date to be stored but also for it to auto update in the box when the form is opened. When someone accesses the form the two boxes that should be automatically filled with current info are the date(Julian) and time. When the form is submitted they should be...

I don't think so. Its a simple text box used for auto updating. I think there's a setting change somewhere. I know that they started by putting the text box then edit it somehow to show the time or date. How, I don't remember. And out of curiosity, what do the different parts of...

Sorry if the question was vague. Let me explain in better detail. I have forgotten how to setup the text box in the form for the date, and I don't know where to implement the techniques you guys provided. On the database I'm currently trying to reproduce there are separate date and time text...

Hello, I have a form that I need to have an auto updating date box in, which would be logged with the info entered into the form. I also need it to be in Julian date format. e.g. todays date 7/7/2013 would be 13188. How would I go about doing this?