Search results

I have field with decimals and it's showing correctly but I want to custom format the field, add some text. My report format is ="~" & [Decimal] but I'll got 10 or 3 instead of 1,0 or 0,3. In a table is the field showing correctly. Should be easy, I'm sorry. Thanks.

Pat's information helped me, thanks!

How to change primary key in main table and in subtable at once?

Works somehow. But report shows only 2 first pages and then 'run-time error 2101: the setting you entered isn't valid for this property'. And fields are selectively shown in appropriate font, most fields are in default box font. Thinked it should have been easy but not.

I'm managing a font database and want some kind of report. The question is how to format records with fonts found in database? All the fonts are installed to system. Thanks.

Access help doesn't contain any encoding values. I use OutputTo and want the file appear in Baltic. Thanks.

Format() in that row helped, thanks.

In a report there is a text box which has the following source: ="Title: " & [field1] & " sometext " & [field2] General question is how to format those fields? Thanks.

Format(YourDate,"mm-dd-yy") worked. Love simple things!

I'll give a try, and let you know.

Towards the right way but I want 99 instead of 1999.

How to generate a filename that uses date values? For example, date value is November 21, 1999 and filename should be 21-11-99. Problem was how to separate date parts. Thanks

Separate fields? Not the thing I intended. @ the present time I type 0:03:12 to get the final result as 3 mins and 12 secs. Can't omit zero (or whatever first numeric) cause the result will turn then to 3 hours and 12 mins.

How can I type minutes & seconds only into date/time field. Formatted as nn:ss and pattern as 0:00:00;*. AND here comes that annoying must-be-typed zero, I want to type mins and secs only. Thanks.

maybe u want to try the database... http://sven.future.ee/m.zip

Ah, I'm so angry but I found an older copy of the database. Must type again. Dammmmn!

There is no .ldb file and can't export or import. Still the same banner.

Oh god, since there are NO OTHER users logged on I can't understand where's the point. Is my database gone?

It worked but I put the code to Detail_Format and dropped me.repaint (it gave errors). And I have large enough field to accept any sizes. Thanks!

How can I set font size of a field based on a value of another field? Example, font size of field1 should be 126 points cause field2 value is 126. Thanks.