Replies

Where are you putting your code? I think that it needs to be in the Detail-Format, Something like

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If me![OwnSVF] = -1Then
cbS.Visible = True
else
cbS.Visible = False
End If
End Sub

HTH

Peter

Using W98 and IE6 at home.
First opening had the fault, I changed the font size of the viewer and that cured it. but after that it opened ok regardless of the font setting!

Maybe something to do with the font it is coded with?

use the “InStr Function”, You can find it in help

Peter

Are you recording these blocks as “from” “to” fields or as individual records?
If you are entering individual serial numbers Access will automatically prevent people inputting non-unique data for you if the record is set to index – Yes (No Duplicates).

If you want to know how many numbers are unused you could use a record count against last serial number to find out.

If you are putting the numbers in as blocks you could probably use code to validate the numbers and add them to a table as individual records for you

HTH

Peter

No problems with Win2K and IE5 here

Peter

Just add the $ sign and number of Decimals you need

“$”#,##0.0000 “Text”

HTH

Peter

I did not think to look a cell alingment

The workbook was just as I opend it with Exporer, but I tried copying the cells over to excel proper and got the same effect.

copying the cell left it the same, but copying the formula from the edit bar and pasting it into another cell broke the thing!

Peter

Curiouser and Curiouser!!

The formula worked just fine as it was for me! Until I re-wrote it elsewhere!!
If you look at the attached picture you will see that after deleting B15:C15, F7 gave the result 0.5 (as a number) but when I retyped the formula in F8 I got 0.25 as text!
Copying or dragging the formula still gives me the correct (but wrong?? ) result

Think that I will need stronger tablets now LOL

Finding out how much consultants get to do this will be interesting to us wage slaves!!
Especially as Access is just something that has to be fitted in between real work

It also tarts up the bars in Outlook Express

I am not sure in what way the calculation is incorrect.
It seem to be doing what it should be. ie
with your figures in B15:C15 the max is greater than 0.46 and your formula gives 0.25
delete them and the max is not greater than 0.46 and the formula gives 0.5

What were you expecting to get?

Also posibly a search for *.mdb and temporarily rename them until the culprit is found?

Thanks for the Link. I will go take a peek at it.

Peter

Many Thanks

Is this Lookup based on a table or with the details typed into its Row Scource? I belive that data listed in the row scource is treated as text

Peter